Difference between dates

[laqa]

Hello, I am trying to display a cell with the difference between two dates (=V4-V3) and I am receiving as result 1/30/1900. Dates are 01/21/11 and 12/22/10. Result should be 30.

Thanks,

Luis.

[DonkeyOte]

Dates are just numbers - they appear as they do because of the format applied to them - format your result cell as General and you will see 30.

(on 1900 date system 1 equates to 1/1/1900 so 30 equates to 1/30/1900)

[edvwvw]

Hi - welcome to the board

format your result cell as number.

edvwvw