Avatar of swjtx99
swjtx99

asked on 

Multiple IF's

Hi,

I have a formula: =IF(INT(G139)=INT(TODAY()),0,NETWORKDAYS(G139,TODAY(),Holidays))

This does not work for me. If the date is yesterday, it says 2 if it's tomorrow, it returns -2.

What I need is:
If the date is today = 0
If the date is yesterday = 1
if the date is the day before yesterday = 2
ect.
if the date is tomorrow = -1
if the date is the day after tomorrow = -2
Ect.

Thanks in advance,

swjtx99
Microsoft Excel

Avatar of undefined
Last Comment
swjtx99

8/22/2022 - Mon