How to have an IF statement w/ NETWORKDAYS return a 0 when there is no date?

[Tpulcino]

I'm working in a data table trying to capture the amount of actual business days it takes to complete a project.

I have two different columns to capture the start and end dates of a project: "Actual_St_Dt" and "Actual_End_Dt". In some cases the Actual_End_Dt has not yet been filled with a date because the project has not yet been completed.

When there is no Actual_End_Dt I want the returned value to come back blank ("").

The formula I currently have in the column labeled Actual Business Days to Complete returns the value as -29534.

=IF(Table1[[#This Row],[Target_End_Dt]]="","",NETWORKDAYS(K2,M2))

thanks

[Pete_UK]

Well, just to be safe check both of them:

=IF(OR(K2="",M2=""),"",NETWORKDAYS(K2,M2))

assuming the dates are in columns K and M.

Hope this helps.

Pete

[Tpulcino]

Worked like a charm! Thank you! I think I was over engineering the process.