G Guest Apr 22, 2004 #1 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
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 Apr 22, 2004 #2 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.
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. Apr 22, 2004 #3 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.
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.
