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.
This conversation is currently closed to new comments.
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.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Calculate Average Days in Excel