View Single Post
Old 04-19-2019, 09:43 AM
Matthijs2005 Matthijs2005 is offline Windows 10 Office 2013
Join Date: Apr 2019
Posts: 1
Matthijs2005 is on a distinguished road
Default MS project countdown #error

Dear all,

I created in field text1 the countdown formula: DateDiff("d",Date(),[Finish]) and this works well. I have certain rows not indicating a Finish date and then resulting in Text1 as an #ERROR. I tried to implement an IF function, but below ones are already dissaproved in the formula input field. Anyone an idea how to hide an #ERROR?

IIF([FINISH] = , , DateDiff("d",Date())

IIF([Text1] = #ERROR , , DateDiff("d",Date())
Reply With Quote