If column not blank, then Difference between two days

Platform discussions Special workflows & use cases
1

I am struggling with writing the correct formula.

IF, Submitted column is blank, AND CTC column is blank, then Days to CTC column should be blank

IF, Submitted column has date, AND CTC is blank, then Days to CTC column should display the number of the WORKDAYS since Submitted, minus 1 (not counting day 1)

IF, Submitted column has date, AND CTC has date, then Days to CTC column should display number of WORKDAYS between Submitted and CTC, minus 1 (not counting day 1)

Basically I want to combine 3 formulas. The first two below are working when used alone.

IF({Submitted},
WORKDAYS(TODAY(),{Submitted})-1)

IF({CTC},
WORKDAYS({CTC},{Submitted})-1)

image
image1228×532 79.6 KB

2

@JCorrell - I am sure you could come up with a solution in 10 seconds flat. I’ve been watching hours of your videos. :crazy_face:

3

@karinav

LOL, you are greatly over calculating my speed! Just because I can do a few things that others might give up on does NOT mean that I can do them instantly.

Try this:

IF({Submitted}, 
   IF({CTC},
      WORKDAYS(IF({CTC},{CTC},"1/1/1"),
         IF({Submitted},{Submitted},"1/1/1")) - 1,
      WORKDAYS(TODAY(), 
         IF({Submitted},{Submitted},"1/1/1")) - 1),
   ""   
)

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Excel)