Count Days in Phase by using Milestone Dates

[rz6657]

Count Days in Phase by using Milestone Dates using the Date Conditions in Column U... This could be a simple solution but I ran into a wall when both date conditions are not met... I've attached a sample file... thx

Update: I was able to add a formula by searching the forum. However, in column I and O there are some where the previous date condition is not met (it's blank) and it's returning a 5 digit number by default. How can I add an IFERROR so that it comes back a "0" (zero)?

Update 2: added a new sample file with the errors; Keep in mind that the Details tab pulls from the milestones tab with a vlookup formula. I only pull in the most used milestones out of 30 of them...

[AliGW]

Try this:

=IF(OR(ISBLANK(F4),AND(ISBLANK(F4),ISBLANK(H4))),0,IF(ISBLANK(H4),TODAY()-F4,H4-F4))

[bebo021999]

A bit shorter:

=IF(F4="","",(H4="")*TODAY()+H4-F4)

[rz6657]

These work but when since the other columns have a vlookup formula to pull in the dates, I'm either #VALUE! or #N/A errors. Is there a way to add an IFERROR to still count?

[AliGW]

Provide a workbook that shows the issue you are now describing.

[rz6657]

Hi AliGW, I've uploaded a new sample file.

Update 2: added a new sample file with the errors; Keep in mind that the Details tab pulls from the milestones tab with a vlookup formula. I only pull in the most used milestones out of 30 of them...

[AliGW]

Try this:

=IFERROR(IF(OR(ISBLANK(F4),AND(ISBLANK(F4),ISBLANK(H4))),0,IF(ISBLANK(H4),TODAY()-F4,H4-F4)),0)