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.
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…
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
todaythe 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…
Go figure
Ah ok well seen.
thank you so much