Question Locked

Calculate Average Days in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Question: I need to know the formula in Excel to calculate average days. Tracking information and need help. Ex: 30 days in April, I have a number of 72 units in database, how do I get the average? And then at the end of May, I have 90 units in database from April to the end of May. What's my average days in May? Thanks.

2 replies

by oldbaritone

are floating-point numbers. The integer part is the day, and the fractional (decimal) part is the time, as the fraction of 24 hours.

To get the difference between dates and times, you can subtract one from the other. If you only want the date, then truncate the values to integers before beginning.

Caution: When doing averages, remember that a "fractional day" in the system is based on a 24-hour day, NOT an 8-hour work day.

http://www.cpearson.com/excel/datearith.htm

This discussion is closed to new replies.