| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Average is easy: Sum/Count
HTH. Best wishes Harald "Mark" <(E-Mail Removed)> skrev i melding news  A25651D-D0FD-4C12-9CD5-(E-Mail Removed)...> 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news A25651D-D0FD-4C12-9CD5-(E-Mail Removed)...> 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 |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Averaging a Value Between Two Serial Dates | ChrisM | Microsoft Excel Programming | 4 | 15th Nov 2005 10:10 PM |
| averaging a value between two serial dates | ChrisM | Microsoft Excel Discussion | 1 | 15th Nov 2005 09:58 PM |
| Averaging multiple dates | =?Utf-8?B?TWF0dCBIYW1pbHRvbg==?= | Microsoft ASP .NET | 4 | 24th Mar 2005 07:21 PM |
| Averaging Dates | Frank | Microsoft Access Reports | 3 | 12th Feb 2004 04:15 PM |
| Averaging using IF statements between Dates | Steve Kay | Microsoft Excel Worksheet Functions | 2 | 3rd Oct 2003 06:34 PM |
