| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average days between multiple dates
A1:A200
01/07/08 07/07/07 04/23/07 11/30/06 C1: I need average days between dates, considering leap years. And is it possible to format C1 to equal.."2 month 3 days" Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average days between multiple dates
=AVERAGE(A2:A200-A1:A199)
Commit with Shift+Ctrl+Enter (array formula) HTH Kostis Vezerides On Apr 4, 6:41 pm, Jman wrote: A1:A200 01/07/08 07/07/07 04/23/07 11/30/06 C1: I need average days between dates, considering leap years. And is it possible to format C1 to equal.."2 month 3 days" Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average days between multiple dates
i keep getting 198. 81 although i change dates.
"vezerid" wrote: =AVERAGE(A2:A200-A1:A199) Commit with Shift+Ctrl+Enter (array formula) HTH Kostis Vezerides On Apr 4, 6:41 pm, Jman wrote: A1:A200 01/07/08 07/07/07 04/23/07 11/30/06 C1: I need average days between dates, considering leap years. And is it possible to format C1 to equal.."2 month 3 days" Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average days between multiple dates
Yes you a now that I thought it over again and tested it, obviously
the average will be equal to the last date minus the first date divided by the number of dates. Hence if you change any intermediate dates the average will stay the same. It will only change if you change the 1st or last date. Does this help? On Apr 4, 7:12 pm, Jman wrote: i keep getting 198. 81 although i change dates. "vezerid" wrote: =AVERAGE(A2:A200-A1:A199) Commit with Shift+Ctrl+Enter (array formula) HTH Kostis Vezerides On Apr 4, 6:41 pm, Jman wrote: A1:A200 01/07/08 07/07/07 04/23/07 11/30/06 C1: I need average days between dates, considering leap years. And is it possible to format C1 to equal.."2 month 3 days" Thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average days between multiple dates
oh. i see.
thanks "vezerid" wrote: Yes you a now that I thought it over again and tested it, obviously the average will be equal to the last date minus the first date divided by the number of dates. Hence if you change any intermediate dates the average will stay the same. It will only change if you change the 1st or last date. Does this help? On Apr 4, 7:12 pm, Jman wrote: i keep getting 198. 81 although i change dates. "vezerid" wrote: =AVERAGE(A2:A200-A1:A199) Commit with Shift+Ctrl+Enter (array formula) HTH Kostis Vezerides On Apr 4, 6:41 pm, Jman wrote: A1:A200 01/07/08 07/07/07 04/23/07 11/30/06 C1: I need average days between dates, considering leap years. And is it possible to format C1 to equal.."2 month 3 days" Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Average Days Open IF between dates | Excel Worksheet Functions | |||
| AVERAGE DAYS OPEN IF BETWEEN DATES | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Linear Mode
