From the course: Microsoft Project Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Working days, part 2: Add error test for missing dates

Working days, part 2: Add error test for missing dates

From the course: Microsoft Project Tips Weekly

Start my 1-month free trial Buy for my team

Working days, part 2: Add error test for missing dates

“

- [Bonnie] Hi, I'm Bonnie Biafore. If you created the formula in last week's tip to calculate the number of workdays between two dates, you might have noticed that when either of the dates is missing, the formula displays an error. Well, I want to edit this custom field because I'm going to edit the formula to add in a test. So I'm going to right-click and then choose Custom Fields. That opens up the Custom Fields dialog box to my custom field, and I'm going to drag this over to the side. So that way I can see the rows with my tasks and the values for Baseline Finish and Baseline1 Finish. Let's go ahead, in the Custom Fields dialog box, click the Formula button, so that we can see the formula that we have. We want to test to see if a date is missing, and we're going to set the result to zero days if either or both dates are missing. To do that we need an if-then function. I'm going to make sure that the cursor is at the…

Contents