How to calculate # of Working Dates from Start Date to Today if there is Text in another Column

Jeffrey Homme

I'm trying to see how many Working Days has passed from todays date when there is a Date in Project Start Date column and the # of Days from Project Start to Baseline column is "Not Yet Baselined".

If the # of Days from Project Start to Baseline column has a Date then # of Days of non-Baselined to Today should say "Baselined".

Thank you

David Joyeuse

Hi @Jeffrey Homme

If I understood you correctly, try this in # of Days of non-Baselined to Today

=IF(ISDATE([# of Days from Project Start to Baseline]@row), "Baselined", NETWORKDAYS([Project Start Date]@row, TODAY()))

Hope it helped!