PDA

View Full Version : Solved: Error with Date calculation



volabos
12-01-2008, 04:45 PM
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
12-01-2008, 04:54 PM
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
12-01-2008, 05:09 PM
Ah..............my mistake. Thanks GTO