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)

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

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

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

"Joel" wrote:

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

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

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.

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

"Anthony" wrote:
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.

<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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jozef carpenter" wrote in
message ...
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

"Anthony" wrote:
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.

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.