Formula combining workdates and dates (again...)
Workdates continue to plague me... :)
I have the following fields;
[estimated start] [estimated end] [estimated duration]
[actual start] [actual end] [actual duration]
[calculated end date]
Of which [estimated start] and [calculated end date] are work dates to support predecessors (the [calculated end date] feeds into the [estimated start] of the next task). There are two formulas, one is for [estimated finish] and one is for [calculated end date]
1. [estimated finish] = [estimated start] + [estimated duration]
This one works fine, after changing [estimated duration] to a numeric (thanks to Gil for pointing that one out)
2. Formula for [calculated end date] field I have is;
If(
not IsNull ([actual finish]), [actual finish],
not IsNull ([estimated finish]), [estimated finish])
What I want it to do is basically look at the [actual finish] field, if that is not blank then use the date in that field for the [calculated finish] date else look at the [estimated finish] field and use the date there (if both are blank then remain blank)
I'm hoping I haven't totally borked the formula above but I'm getting a "expecting workdate but found date" error, if I adjust it to ToDate([actual finish]) I get a "expecting text/datetime/workdate but found date".
I'm sure there is going to be an simple answer to this one that I will kick myself about later, but I'm missing it right now, could anyone suggest a way to do this?