Function returning unexpected value
I am using Excel 2007.
I have the function:
=IF(AND(ISBLANK(Milestones[[#This Row],[Actual Completion
Date]]),ISBLANK(Milestones[[#This Row],[Updated Projection
Date]])),TODAY()-Milestones[[#This Row],[Baseline Planned
Date]],IF(AND(ISBLANK(Milestones[[#This Row],[Actual Completion
Date]]),(ISBLANK(Milestones[[#This Row],[Updated Projection
Date]]=FALSE))),TODAY()-Milestones[[#This Row],[Updated Projection
Date]],Milestones[[#This Row],[Actual Completion Date]]-Milestones[[#This
Row],[Baseline Planned Date]]))
I am expecting to get the value of 5 (today - 7/17/2009). Instead, I am
getting -39992. Can anyone help me find where I am going wrong? I have
looked for so long that I am unable to locate my error.
Thank you,
-- Paul
|