I have a spreadsheet with three columns for "Date", "Currency", and "Amount".
Date Currency Amount Month
06.02.2015 EUR 188 March
30.01.2015 EUR 285 January
I create the "Month" column from the Date-Column using the following formula and then formatting the "Month" column to MMMM:
=DATE(YEAR(A2);MONTH(A2);DAY("0"))
(I do this because I need to group the data in a Pivot-Table by month.)
The Problem: As you can see from the excerpt, the month returned for the first value for month is incorrect. It says "March", when it really is "February". What am I doing wrong here?
For the first month-value (or values, depending on how many entries there are for the first listed month) in the spreadsheet, libreCalc always seems to count one month ahead. The remaining values, starting from the next month, are always correct and work just fine. It makes no difference whether the months are listed January-December or the other way around, as in my example.
Thanks for helping!