Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For days, you don't need DATEDIF.
=B1-A1 will do, if you format the result as Number or General. DATEDIF makes sense if you are looking at months and/or years. -- David Biddulph Anthony wrote: On Jan 3, 2:34 pm, jozef carpenter wrote: hi all, happy 2009! does someone know the option of calculating the amount of days between 2 entered dates, so i can claculate the average electricity use? many thnx in advance. jozef carpenter (so not yet :-) an excel wizard) This has worked for me in the past and can be used for number of days, months, etc. between two dates: =datedif(A1, B1, "d") where cells A1 and B1 contain the two dates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I calculate the number of business days between two dates | New Users to Excel | |||
calculate number of days btw dates | Excel Worksheet Functions | |||
Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
Calculate number of days in a column of dates | Excel Discussion (Misc queries) |