Today is between Two Dates

[biha]

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”,

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

Third, template column (Start - End),

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

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

[Darren_Murphy]

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

[biha]

Oh how small my brain is…

[Darren_Murphy]

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