Processing Time (Days)

Marilen.Navarro103391

Hello-

Can you help me with my formula? Processing time is "0" should be 1 day.

Thanks.

=IFERROR(IF(NOT(ISBLANK([Date Recorded Quote]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Quote]@row), IF(NOT(ISBLANK([Date Recorded CE Leads]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded CE Leads]@row), IF(NOT(ISBLANK([Date Recorded Pipeline]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Pipeline]@row), IF(NOT(ISBLANK([Date Recorded for PO Submitted]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for PO Submitted]@row), IF(NOT(ISBLANK([Date Recorded for Others]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for Others]@row)))))), "")

Genevieve P.

Hi @Marilen.Navarro103391

What date is in your [Date Started] column? Is it the same (11/26/23)?

Note that the 26th is a Sunday which means it's not a working day. That means if your Start Date is 11/26/23 and your End Date (Date Recorded Quote) is 11/26/23, the Networkdays is 0, since there are no working days present.

Do you mean to use the NETDAYS Function instead, to include Saturdays and Sundays in your count?

Genevieve P.

Haha no problem at all! 🙂 Here you go:

https://media.giphy.com/media/l1IY8onMgFEotIzew/giphy.gif

Genevieve P.

Hi @Marilen.Navarro103391

What date is in your [Date Started] column? Is it the same (11/26/23)?

Note that the 26th is a Sunday which means it's not a working day. That means if your Start Date is 11/26/23 and your End Date (Date Recorded Quote) is 11/26/23, the Networkdays is 0, since there are no working days present.

Do you mean to use the NETDAYS Function instead, to include Saturdays and Sundays in your count?

Marilen.Navarro103391

@Genevieve P. Thanks. I should drink coffee first. :)

Genevieve P.

Haha no problem at all! 🙂 Here you go:

https://media.giphy.com/media/l1IY8onMgFEotIzew/giphy.gif