Ask Your Question

year formular doesn't work correctly [closed]

asked 2013-09-09 11:40:31 +0100

ROSt52 gravatar image

updated 2015-11-07 23:50:22 +0100

Alex Kemp gravatar image

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.)

image description

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: OS: XP/SP3

Any help is appreciated

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 2015-11-07 23:50:38.701867


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.

B.Horvat gravatar imageB.Horvat ( 2013-09-09 14:04:14 +0100 )edit

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.

ROSt52 gravatar imageROSt52 ( 2013-09-09 16:58:14 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-09-09 15:45:26 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more


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

ROSt52 gravatar imageROSt52 ( 2013-09-09 17:01:51 +0100 )edit

Question Tools

1 follower


Asked: 2013-09-09 11:40:31 +0100

Seen: 325 times

Last updated: Sep 09 '13