Forum Discussion
Solved
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...
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.
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.
- It worked. Thank you so much!!
