Current location - Health Preservation Learning Network - Fitness coach - Excel calculates the month when the fitness card is used up?
Excel calculates the month when the fitness card is used up?
This requires an agreed consumption algorithm. Such as initial date+remaining times/average daily consumption times.

Daily consumption times = current annual usage times /365. Then just format the result as a date.

= B2+(c 15-c 14)/(c 14/365)