# Date to number

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.

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

no

What does the number 44307 represent in this example?

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

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!

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…

3 Likes

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.

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

Go figure

2 Likes

Ah ok well seen.
thank you so much

2 Likes