Hello hive mind,
Im running my accounts in an elaborate calc file and as of LO 5.2 (through to 5.4) I got a weird issue (hence I am still running 5.1):
I got a sheet for paid invoices (Einnahmen) which is pulling the date from another sheet (Rechnungen) with
This is column C in ‘Einnahmen’.
Then in my assessment sheet I try to reference to that date in
This should give me an monthly overview which part of my business has generated how much income.
Up until 5.1 that was working fine. From 5.2 onwards I get #VALUE! as error. The cell formatting seems to be fine and for my expenses (same sheet) it works fine (though that doesn’t use referenced dates).
SUMPRODUCT without the MONTH part works so I am led to believe that its somewhere in the referenced date that things go wonky however MONTH on its own gives a valid value of the referenced date - I am stumped.
Any help at this point is much appreciated.