how can i calculate the number of days passed between 2 dates ente

  • Thread starter jozef carpenter
  • Start date
J

jozef carpenter

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)
 
J

Joel

It is simply subtracting the two days but the resulting cell with the formula
must be change to Number format instead of a date.

A1 = 1/1/2009
A2 = 1/5/2009
A3 = A2 - A1
 
A

Anthony

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)
Click to expand...

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.
 
J

jozef carpenter

thnx for effort anthony, but if i do copy paste (so no spelling errors) it
unfortunately does not work... hwat is the "d"? and should they range not
have a colon instead of comma? and what does datedif actually do? they other
given solution did do the job, so i have a solution, but this intrigues me
now..... maybe u can clarify it a litlle bit more? im from the netherlands so
not a native english speaker (maybe this plays a role in misinterpreting what
you say...?). thnx again and looking 4ward to hear more. jozef
 
D

David Biddulph

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.
 
Top