# Date to number

**URL:** <https://community.glideapps.com/t/date-to-number/25857>\
**Category:** Ask for Help\
**Created:** [April 21, 2021, 2:52pm UTC](https://community.glideapps.com/t/date-to-number/25857 "2021-04-21T14:52:04Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 21, 2021, 2:52pm UTC](https://community.glideapps.com/t/date-to-number/25857/1 "2021-04-21T14:52:04Z")

</div>

Hello,  
I need to convert a date in a glide table to numeric format (like the one in google sheet).  
Example  
it’s Wednesday April 21, 2021 = 44307.  
I saw it somewhere on the forum but couldn’t find it.  
Thank you in advance.

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 21, 2021, 2:59pm UTC](https://community.glideapps.com/t/date-to-number/25857/3 "2021-04-21T14:59:27Z")

</div>

Bonjour,  
oui mais je dois faire le calcul dans une colonne math ?

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 21, 2021, 3:14pm UTC](https://community.glideapps.com/t/date-to-number/25857/5 "2021-04-21T15:14:19Z")

</div>

no 🤨

---

<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 21, 2021, 3:17pm UTC](https://community.glideapps.com/t/date-to-number/25857/6 "2021-04-21T15:17:58Z")

</div>

> [@Manu.n](#):
>
> it’s Wednesday April 21, 2021 = 44307.

What does the number 44307 represent in this example?

Edit: Okay, it’s the output from the sheets `DATEVALUE()` function…

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 21, 2021, 3:22pm UTC](https://community.glideapps.com/t/date-to-number/25857/7 "2021-04-21T15:22:07Z")

</div>

Example in google sheet  
if you enter a date in a cell and select the format over number.

EDIT : yes like the DateValue function but in a Math column!

---

<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 21, 2021, 3:28pm UTC](https://community.glideapps.com/t/date-to-number/25857/8 "2021-04-21T15:28:05Z")

</div>

Okay, so it looks like it’s the number of days since Jan 1st 1900. Therefore, all you need to do is:

- Create a date column and populate it with Jan 1 1900 in every row
- Create a math column that subtracts that column from ~~today~~ the date you want to convert

Edit: Like this…

 ![Screen Shot 2021-04-21 at 11.31.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c792f666f7fbb6bf8522a9c68c6e391041f263f.png)

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 21, 2021, 3:47pm UTC](https://community.glideapps.com/t/date-to-number/25857/9 "2021-04-21T15:47:44Z")

</div>

Yes thank you @Darren_Murphy  
I was on something more complicated but it seems to work.  
you just have to add 2 to the result to get it right.  
I don’t know why because 1/1/1900 is a known reference date.

---

<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 21, 2021, 3:53pm UTC](https://community.glideapps.com/t/date-to-number/25857/10 "2021-04-21T15:53:05Z")

</div>

Looks like `DATEVALUE` actually uses `1899-12-30` as a base, so that explains the difference…

![Screen Shot 2021-04-21 at 11.51.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02639bb3362c62bb1bda37e77a1562dda12c142c.png)

Go figure 🤷‍♂️

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [April 21, 2021, 3:54pm UTC](https://community.glideapps.com/t/date-to-number/25857/11 "2021-04-21T15:54:41Z")

</div>

Ah ok well seen.  
thank you so much 👍

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/date-to-number/25857/12 "2024-01-17T16:52:33Z")

</div>