Averaging Dates

[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

 

[Harald Staff]

Average is easy: Sum/Count

HTH. Best wishes Harald

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.

 

[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.

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.