Today is between Two Dates

Ask for Help
1

I need to do leave calendar, so if today is included in the leave duration, show “On Leave”.
Technically, the formula would be =IF(AND(B1<=TODAY(),C1>=TODAY()),“On Leave”," ").

So first, what i made is using the if-then column (Start Date), turn up as “Yes”,
image

Second, if-then column (End Date), turn up as “Yes”,
image

Third, template column (Start - End),
image

Fourth, if-then column , will show who on leave,
image

But why some not applicable :
eg: row 211
my question is why ?
image

image
image826×512 87.2 KB

2

You could do this with a single if-then-else column.

  • If Start Date is after today, then false
  • If End Date is before today, then false
  • Else true
3

Oh how small my brain is…

4

Hey, if you asked me a year ago, I probably would have done something similar to what you were trying to do. Except I would have used about 4 extra columns :wink::crazy_face: