Formula Variance Help

Scott2023

Good Afternoon. I am looking to set a Baseline Start and End date; however, I have several Phases that I would like to include to capture the change in phases. (i.e., prospecting how many days we have prospected a client and when the transition to implementation goes live. Etc. Is there a way to capture the movement in phases with the below formula as I keep getting the return of #UNPARSEABLE

Thank you!

=IFERROR(NETWORKDAYS([Actual Finish Date]@row, [Baseline Finish Date]@row), "Prospecting")

Scott2023

@KPH Apologies, but I have one additional query and wanted to see if I could get your assistance or thoughts. Much appreciated!

KPH

Are both of the Date columns set up as Date Type?

Scott2023

Yes, they are both set up as date columns, and the "prospecting" column is set up separately

Scott2023

@kph any thoughts? Thanks Much Appreciated!