Date to number

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

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

no :face_with_raised_eyebrow:

What does the number 44307 represent in this example?

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

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!

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…


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…

Screen Shot 2021-04-21 at 11.51.10 PM

Go figure :man_shrugging:


Ah ok well seen.
thank you so much :+1: