Averaging Dates

M

Mark

I have a column of dates (DOB) for which I want to find the average DOB? I know it is simple but I cannot seem to make it work

Thanks in advance
 
H

Harald Staff

Average is easy: Sum/Count

HTH. Best wishes Harald

Mark said:
I have a column of dates (DOB) for which I want to find the average DOB?
Click to expand...
I know it is simple but I cannot seem to make it work.
 
D

Dave R.

With dates in A1:A10, have you tried =AVERAGE(A1:A10)

?

Dates in Excel are numbers (I write this on 38099), so you can average dates
just like any other numbers.



Mark said:
I have a column of dates (DOB) for which I want to find the average DOB?
Click to expand...
I know it is simple but I cannot seem to make it work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with average/lookup formula 2
Cell data entering slow! 0
countifs Function not giving desired result with date criteria 2
How can i find the max value within a time range ased on two cells 6
calculate average values for 100 records in the shortest way? 5
200KB versus 35MB 0
Using a Date and corresponding weekday to pull amounts 1
averaging multiple items from one list 2

Top