`Days` and `Day` are easy to confuse

[Paul_Danyliuk]

Here’s the background:

Day formula is calculating correctly but the cell is showing a wrong result

Make your Day column a Number type. Why this is happening: Dates are actually Numbers in Coda, e.g. today is 44220. This is the number of days since 12/30/1899 12:00 AM in the local timezone (for some reason it’s not 1/1/1900 but this): [image] Time is fractions of days, e.g. today 12 PM would be 44220.5, and today 6 PM would be 44220.75. What you see is Day(Start time), which is 22, converted to the “22 days since 12/30/1899”, which is Jan 20. So yeah, just change the column format to Numb…

What Day(1) does is first converts 1 to DateTime, resulting in 12/31/1899, then take a month day out of it, which is 31.

Days(x) sorta does nothing because 1 day = 1 as a number. It’s just syntactic sugar.

So Date(2021, 11, 1) + Day(1) is the same as Date(2021, 11, 1) + 31 and also the same as Date(2021, 11, 1) + Days(31)

But yes, easy to confuse.