Ask Your Question
0

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
2

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

Mike Kaganski gravatar image

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

Comments

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

Stats

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

Seen: 74 times

Last updated: Jan 23