troubleshooting Question

Multiple IF's

Avatar of swjtx99
swjtx99 asked on
Microsoft Excel
20 Comments1 Solution64 ViewsLast Modified:

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
if the date is tomorrow = -1
if the date is the day after tomorrow = -2

Thanks in advance,

Join our community to see this answer!
Unlock 1 Answer and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros