Ask Your Question

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-21 15:13:59.301827

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

Question Tools

1 follower


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

Seen: 144 times

Last updated: Jan 23 '17