Ask Your Question

Why is =MONTH("2017-01-01") showing December?

asked 2017-01-23 20:43:20 +0200

ryanrowe gravatar image

I have a cell with a formula for a date that is in January. It shows a result of "1". When I format the date using a format of MMM it shows December. Why?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-23 21:34:48 +0200

updated 2017-01-23 21:36:07 +0200

Because when you use function MONTH, you get not a date, but a number of month. That number is one. When you take the one and try to represent it as a date, it is treated as the day one of the epoch (which is 31/12/1899). So, formatting the value to show month gives you "a month of number one" that is December.

edit flag offensive delete link more


the so called epoch is not identical to to "day zero" ( 1899-12-30 ) in LibreOffice.

see epoch

karolus gravatar imagekarolus ( 2017-01-23 23:56:11 +0200 )edit

The so called Unix time is not identical to epoch ( 1899-12-30 ) chosen in LibreOffice. see epoch

Mike Kaganski gravatar imageMike Kaganski ( 2017-01-24 05:43:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-23 20:43:20 +0200

Seen: 122 times

Last updated: Jan 23 '17