| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to get an AVG date?
Is there a way to calculate the average date for a # of dates? thanks!
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way to get an AVG date?
You can just use the average function. Dates are ultimately just stored as
long integers so the average works just fine... -- HTH... Jim Thomlinson "mikeb" wrote: Is there a way to calculate the average date for a # of dates? thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way to get an AVG date?
You may want to INT it
=INT(AVERAGE(rng)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim Thomlinson" wrote in message ... You can just use the average function. Dates are ultimately just stored as long integers so the average works just fine... -- HTH... Jim Thomlinson "mikeb" wrote: Is there a way to calculate the average date for a # of dates? thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a way to get an AVG date?
thanks to both of you!
"mikeb" wrote: Is there a way to calculate the average date for a # of dates? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
