So, for a few years I was successfully using this formula in the 6.3 version of LO Calc:
To sum all numbers in Column “O” when:
*Column “T” has cells with any day of March/2022. (The day is not important, just the month and year)
*Column “A” has cells with a “C” letter as text.
But after updating to 7.6.2, all my formulas (about a hundred of them, lol) were resulting to “0”.
(The formula above is just an example, in my sheet I’m using lots of formulas similar to this for other conditions that also depend on date.)
It took me some time to figure out that the problem was the Date Format.
For column “T” I was using the “DD/MMM” display format for the dates (03/mar, 14/apr, 25/may, etc).
It was working fine in the old version, but now I had to convert to the DD/MM/YYYY format to fix all my formulas.
Any way I can better use months and years as conditions in SUMIFS formulas? (The day is not important to the formula, but I still need to insert the correct day in the cells).
My intention is to keep using the “DD/MMM” display format if possible (it’s visually important to me to quickly check it, I use this sheet all day).
Also, where I live day/month/year is the standard date format.
(PS: I know I can just add a new column to copy and visually display the DD/MMM format and keep the other hidden just for the formula sake, but I want to learn how to deal with this problem without this trick, if possible. And sorry, I tried to search for answers by myself, but most topics about this are people using DATE functions, which didn’t help me…)
[erAck: edited to format code as code, see This is the guide - How to use the Ask site? - #6 by erAck]