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,
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,