# Today is between Two Dates

**URL:** <https://community.glideapps.com/t/today-is-between-two-dates/40834>\
**Category:** Ask for Help\
**Created:** [April 18, 2022, 6:26am UTC](https://community.glideapps.com/t/today-is-between-two-dates/40834 "2022-04-18T06:26:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [April 18, 2022, 6:26am UTC](https://community.glideapps.com/t/today-is-between-two-dates/40834/1 "2022-04-18T06:26:51Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/7319f1723f033de7acea74dcdc71ba9eab642b68.png)

Second, if-then column (End Date), turn up as “Yes”,  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0c223118eb5badc2899c66dbf815bef384253df.png)

Third, template column (Start - End),  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6d7c2fca7dc5dcd08c53ea49eb97163c53f5e1c.png)

Fourth, if-then column , will show who on leave,  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/490ecba9151b6e5002b9313446345654a516d447.png)

But why some not applicable :  
eg: row 211  
my question is why ?  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e008bec8ccacad74f7d8f3789c2d02a1a210877.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e68c346edad8ee90d16693d3ecc4fbc479e04f28.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 18, 2022, 9:55am UTC](https://community.glideapps.com/t/today-is-between-two-dates/40834/2 "2022-04-18T09:55:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [April 20, 2022, 1:43am UTC](https://community.glideapps.com/t/today-is-between-two-dates/40834/3 "2022-04-20T01:43:01Z")

</div>

Oh how small my brain is…

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 20, 2022, 4:01am UTC](https://community.glideapps.com/t/today-is-between-two-dates/40834/4 "2022-04-20T04:01:58Z")

</div>

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 😉🤪

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 21, 2022, 4:02am UTC](https://community.glideapps.com/t/today-is-between-two-dates/40834/5 "2022-04-21T04:02:56Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.