# Count Days in Between

**URL:** <https://community.glideapps.com/t/count-days-in-between/32127>\
**Category:** Ask for Help\
**Created:** [September 22, 2021, 8:00am UTC](https://community.glideapps.com/t/count-days-in-between/32127 "2021-09-22T08:00:53Z")\
**Posts on this page:** 2\
**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:** [September 22, 2021, 8:00am UTC](https://community.glideapps.com/t/count-days-in-between/32127/1 "2021-09-22T08:00:53Z")

</div>

Hi, do you guys have an idea on how to count day in between 1st Jan 2021 until today.  
I need to count the utilization or percentage of usage like 1st Jan 2021 until today is 265 days.  
Let say row no 1 that I wrote using Red Pen below is 0 as Start and End Date is on 2020.

Let say item 2 that I wrote is 28 December 2020 to end date 27 January 2021.  
So it will become 27 days since it will be count starting of first January 2021.

And Item 3 is two day from 8 Jan 2021 to 10 Jan 2021.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/8/f8358d8c105c9fda10327e9b16d956fd23d84486.png)

---

<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:** [September 22, 2021, 8:03am UTC](https://community.glideapps.com/t/count-days-in-between/32127/2 "2021-09-22T08:03:31Z")

</div>

Another example is as below :  
Item 4 is from 1 February 2020 to 28 February 2023 . So it will become 265 days.  
it will be count from 1 jan 2021 until today.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27112b4cc2abfe9103d91d28165c72d58e1021f2.png)