Function behaves differently in two PCs

odiseus

New Member
Joined
Aug 2, 2012
Messages
6
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):

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>
 
Looks like I am having trouble with the code. It should read:
"=IF(OR(D5<A5,D5=A5),"Error in Dates",IF(((DAYS360(TODAY(),D5))<0),(D5-TODAY()),(DAYS360(TODAY(),D5))))"<a5,d5=a5),"error in="" dates",if(((days360(today(),d5))<0),(d5-today()),(days360(today(),d5))))<="" html=""></a5,d5=a5),"error>
 
Last edited:
Upvote 0

Forum statistics

Threads
1,226,840
Messages
6,193,279
Members
453,788
Latest member
drcharle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top