Duration column formula: two situations

Brooks

Hello,

I have three date columns involved in the duration:

Date Submitted

Date Completed

For Future Requests

My current duration formula only uses the Date Submitted and Date Completed columns:

=IF(Status@row <> "Complete", NETWORKDAYS([Date Submitted]@row, TODAY()), NETWORKDAYS([Date Submitted]@row, [Date Completed]@row))

I want to create a formula that incorporates two situations: 1) number of weekdays between Date Submitted and Date Completed when "Future Request" is unchecked or 2) number of weekdays between For Future Requests and Date Completed when "Future Request?" is checked.

Any help is much appreciated!

Genevieve P.

Hi @Brooks

Try this:

=IF([Future Request]@row = 0, IF(Status@row <> "Complete", NETWORKDAYS([Date Submitted]@row, TODAY()), NETWORKDAYS([Date Submitted]@row, [Date Completed]@row)), IF(Status@row <> "Complete", NETWORKDAYS([For Future Requests]@row, TODAY()), NETWORKDAYS([For Future Requests]@row, [Date Completed]@row))

It repeats your same formula... once for if the checkbox is 0, or un-checked, and then again if the checkbox is 1, but swapping out [Date Submitted]@row for [For Future Requests]@row .

Let me know if this works for you!

Cheers,

Genevieve