Networkdays Formula

Tarin Horonzy

Help! I've tried a 1000 different versions and nothing has worked quite right yet!

We are counting workdays between a due date (date- due) and date of issue correction (date- corrected).

Also, I don't want to receive the #invaliddata if my date- corrected cell is blank.

I'm good with: =IFERROR(NETWORKDAYS([Date- Due]@row, [Date- Corrected]@row), "")

However, in my mind... issues corrected on the same day should return 0. And currently it returns 1.

Examples:

Date- Due/// Date- Corrected/// TAT Currently/// TAT Desired

3/3/21/// 3/4/21/// 2/// 1

3/3/21/// 3/3/21/// 1/// 0

3/8/21/// 3/2/21/// -5/// -4

Genevieve P.

Hi @Tarin Horonzy

The formula looks correct, however I understand that you don't want a 1 for the same-day (or 1 day). I recently worked with another member on this post, here, to develop a solution around this: https://community.smartsheet.com/discussion/comment/282023

Let me know if the formulas on that thread make sense or if you'd like more help!

Cheers,

Genevieve