Software

Question

Gravatar
Locked

Calculate Average Days in Excel

By jnickens2 ·
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.

1 total post (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Dates in Excel

by oldbaritone In reply to Calculate Average Days i ...

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

Back to Software Forum
1 total post (Page 1 of 1)  

Start or search

Related Forums