https://bugs.documentfoundation.org/show_bug.cgi?id=151164
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #2 from m.a.riosv <[email protected]> --- Created attachment 182664 --> https://bugs.documentfoundation.org/attachment.cgi?id=182664&action=edit Your sample file modified for quarters (In reply to Adam from comment #0) > .... > By the way, please add the date format: > DD.MM.YYYY: HH.MM > Q.YYYY - Q1.2022 - for quarterly statistics > MM.YYYY - for monthly statistics > WW.YYYY - for weekly statistics You can insist, but that it's not going to change the facts. To produce those formats, it's possible formatting the cells. But the function don't use the formats to search, but the values in the cells. See in the attachment, how the function works to calculate for quarter, you can see that there is needed to use true dates for the spreadsheet. -- You are receiving this mail because: You are the assignee for the bug.
