Solved: Error with Date calculation

[volabos]

Hi,

I got a strange problem, while I was trying to calculate the number of days btw two dates Apr-10 2000 and July-10 2000. They are placed in the cells H65 and H66 respectively. I just used the formula : "=H66-H65", however for a "#VALUE" error. Both cells are Date-formatted. Can you please tell me, where is the error?

Regards,

[GTO]

Greetings volabos,

By chance, did you subtract the greater date from the lesser?

Presuming cell H66 = 7/10/2000
and
..............cell H65 = 4/10/2000

whatever cell has the formula should return 91 (presuming the formula cell is formatted for numbers).

Hope this helps,

Mark

[volabos]

Ah..............my mistake. Thanks GTO