Formulas work for me but not for everyone

I have created a spreadsheet for keeping statistics for the job. There are many sheets and many formulas that retrieve data from other sheets and many formulas with several criteria. It works just fi...

excel

Formulas and Functions

HansVogelaar
Dec 08, 2022
Stina_Loedemel

Literal date values in a quoted string are bound to cause problems with different date formats. It's better to refer to cells with dates.

For example, enter the first of each month in column A:

01.01.2022 for Jan in (probably) A10

01.02.2022 for Feb in A11

01.03.2022 for Mar in A12

etc.

Apply the custom number format mmm to these cells, so that you will see Jan, Feb, Mar, ...

In the formula, replace ">=01.01.2022" with ">="&$A10 and "<=31.01.2022" with "<="&EOMONTH($A10;0)

The formulas should then work with different date settings.

Also, if you want to enter the formulas in row 10 and fill down, you should use $T$6:$T$504 etc. Using $ will "fix" the ranges when you fill down.