Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 04-19-2019, 09:43 AM
Matthijs2005 Matthijs2005 is offline MS project countdown #error Windows 10 MS project countdown #error Office 2013
MS project countdown #error
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

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
A grave error in the Project Forum Mattias Chitchat 0 02-01-2017 12:40 PM
MS project countdown #error Error occurred, when I went to open a MS Project schedule. HermannBaumgartner Project 1 10-29-2014 10:58 AM
MS project countdown #error Formula To Calculate Countdown Days To Project Completion Catherine Project 1 02-19-2014 11:15 AM
Login Error in MS Project 2007 awairkar Project 0 02-28-2011 02:39 AM
Error 9571 when opening Project Server from Project Pro mona Project 0 04-24-2007 07:50 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:45 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft