I have a table with projects. The start date is in cell A5 and the due date in cell D5.
I need to know if the dates were entered correctly, and if so how many days remain to the due date (or how many have passed since it).
I have this function (which usually works well):
I need to know if the dates were entered correctly, and if so how many days remain to the due date (or how many have passed since it).
I have this function (which usually works well):
Code:
=IF(OR(D5<a5,d5=a5),"error in="" dates",if(((days360(today(),d5))<0),(d5-today()),(days360(today(),d5))))[="" code]
Strangely on two PCs it provides the expected answers-but on another PC (running the same version of Excel 2007) the third evaluation returns an error #VALUE!
When I try to debug the error I get:
[B]Reference: SheetA!$E$5[/B]
[B]IF(FALSE,#NA,IF(((DAYS360(41126, ”15/8/12”))<0),(D5-TODAY()),(DAYS360(TODAY(),D5))))[/B]
[B]The next evaluation will results in an error.[/B]
Any idea what could cause this?
Suggestions to make the function more robust will be highly appreciated.</a5,d5=a5),"error>