# Format Days Countdown

**URL:** <https://community.glideapps.com/t/format-days-countdown/56256>\
**Category:** Ask for Help\
**Created:** [January 2, 2023, 11:23pm UTC](https://community.glideapps.com/t/format-days-countdown/56256 "2023-01-02T23:23:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![curlynoemi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curlynoemi/32/50544_2.png) [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\
**Post date:** [January 2, 2023, 11:23pm UTC](https://community.glideapps.com/t/format-days-countdown/56256/1 "2023-01-02T23:23:09Z")

</div>

Hi, I want to create a days countdown that displays the days missing until the event.  
I’ve made a “missing days column” but now I don’t know how to format it.

Example: “1 month 5 weeks and 2 days until the event”

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/317d82e8a709bb1abde10dc8fcb2f495b84cade4.jpeg)

---

<div class="post-metadata">

**Author:** ![curlynoemi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curlynoemi/32/50544_2.png) [@curlynoemi](https://community.glideapps.com/u/curlynoemi)\
**Post date:** [January 2, 2023, 11:27pm UTC](https://community.glideapps.com/t/format-days-countdown/56256/2 "2023-01-02T23:27:26Z")

</div>

Also, I’ve calculated the days until the event in the “missing days” column with Google Sheets.  
Is there a way I can do the same in Glide?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [January 3, 2023, 12:11am UTC](https://community.glideapps.com/t/format-days-countdown/56256/3 "2023-01-03T00:11:25Z")

</div>

Hola!

What about the Relative Time plugin? It can help you

> **[Glide • Relative Time column](https://www.glideapps.com/plugins/time-ago)**
>
> Given a date, returns a string with the relative time (e.g. '1 day ago').

---

<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:** [January 3, 2023, 2:51am UTC](https://community.glideapps.com/t/format-days-countdown/56256/4 "2023-01-03T02:51:08Z")

</div>

> [@curlynoemi](#):
>
> Also, I’ve calculated the days until the event in the “missing days” column with Google Sheets.  
> Is there a way I can do the same in Glide?

Absolutely.  
Use a math column with the following formula:

```auto
Trunc(Start - Now)

```

 ![Screen Shot 2023-01-03 at 10.45.26 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a04657799dba5c67c86a36d3e973df30e779f73a.jpeg)