Number of working days between dates and if blank number of days through today

Keij1

Hello, I need help expanding this formula. Currently using IFERROR to calculate the range between columns Project Request Date and Project End Date, if the Project End Date is blank it returns blank; What I would like to happen is the same calculation BUT if the Project End Date is blank (because project is in progress) it needs to calculate the dates between the Project Request Date and Today.

Michelle Choate 2

Using and IF statement, this should work. so IFERROR(IF([Project End Date]@row <>"", NETWORKDAYS([Project Request Date]@row,[Project End Date]@row), NETWORKDAYS([Project Request Date]@row, TODAY())),""

Michelle Choate 2

Using and IF statement, this should work. so IFERROR(IF([Project End Date]@row <>"", NETWORKDAYS([Project Request Date]@row,[Project End Date]@row), NETWORKDAYS([Project Request Date]@row, TODAY())),""

Keij1

That worked. Thank you so much!!

Michelle Choate 2

Glad I could help!