Year formular doesn't work correctly

[ROSt53]

I have a column of dates (delivery dates) with format dd-mmm-yyyyy.

As I need to group by years in a pivot table I need to create a column only with year using the formula YEAR(cell).
(Formatting the column “delivery dates” does not created a grouping by years in the pivot table.)

When I use the wizard for this very function the result is correct in the wizard window. but when i click OK in the wizard, the date appearing as the result in a cell shows always 1905.

My date setting in Tools/Options/LibreOffice Calc/Calculate is 12/30/1899(default)
LibO version: 4.0.5.2
OS: XP/SP3

Any help is appreciated

[B.Horvat]

Check if column Delivery date is in appropriate format (date). I inserted few rows with format dd-mmm-yyyyy in date column, formula YEAR(cell) is correct in next column and in pivot table to.

[ROSt53]

Thanks for your comment. Delivery date column format is dd-mmm-yyyy. Thus I considered the column correct formatted. I also checked if all are date values and changed the date format to 2 - 3 other formats and result was correct… and this became my headaches.

[mariosv]

Hi ROSt52,

It is easy to do in PT, once you have made the PT, go to the column with date inside PT, and use Menu/Data/Group & Outline/Group or [F12], there you can select how to group dates.

[ROSt53]

THANKS this was a great hint. It works just as you described… I should have posted my question earlier…