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 ?