Date to number

[Manu.n]

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.

[Manu.n]

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

[Manu.n]

no

[Darren_Murphy]

@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…

[Manu.n]

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!

[Darren_Murphy]

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…

[Manu.n]

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.

[Darren_Murphy]

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

Go figure

[Manu.n]

Ah ok well seen.
thank you so much