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

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

 

[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

 

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

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.

 

[jozef carpenter]

HI, many thnx! it worked, stupid that i did not recognise this issue.

 

[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

 

[Niek Otten]

<im from the netherlands >

Then you should indeed use semicolons ( instead of commas.

All about the DATEDIF function:

http://www.cpearson.com/excel/datedif.aspx