Add or Subtract a value from a NETDAYS formula

Justin Mauzy

Here is the formula that I have. It works fine except it is one day off:

=IFERROR(NETDAYS([Completion Date]@row, [Due Date]@row), "")

It calculates correctly but I need to adjust by one day:

• If the returned value is equal to or more than 1, I want to subtract 1 (-1)
• If the returned value is equal to or less than -1, I want to add 1 (+1)

Thanks in advance.

Shubham

Hi Justin

I hope you are doing well, 

You can use this formula based on your needs. 

=IFERROR(IF(NETDAYS([Completion Date]@row, [Due Date]@row) >= 1, NETDAYS([Completion Date]@row, [Due Date]@row) - 1, IF(NETDAYS([Completion Date]@row, [Due Date]@row) <= -1, NETDAYS([Completion Date]@row, [Due Date]@row) + 1, "")), "") 

I hope this is useful to you, Have a Good Day. 

Thanks  

Shubham Umale, Smartsheet Engineer, Ignatiuz Software 

Shubham

Hi Justin

I hope you are doing well, 

You can use this formula based on your needs. 

=IFERROR(IF(NETDAYS([Completion Date]@row, [Due Date]@row) >= 1, NETDAYS([Completion Date]@row, [Due Date]@row) - 1, IF(NETDAYS([Completion Date]@row, [Due Date]@row) <= -1, NETDAYS([Completion Date]@row, [Due Date]@row) + 1, "")), "") 

I hope this is useful to you, Have a Good Day. 

Thanks  

Shubham Umale, Smartsheet Engineer, Ignatiuz Software 

Justin Mauzy

It worked perfectly. Thank you.