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)