Forum Discussion
Solved
Refering to a date within another cell when using the COUNTIFS formula
Hey guys,
when I use the COUNTIF formula and write the date into the formula by hand (e.g. "<=01.05.2017") the formula works. However, when I refer to a cell which contains "01.05.2017" (e.g. "<=B12") the formula doesn't work.
I already set the cell "B12" as "date". Still not working..
Any help highly appreciated!
Thanks
Hello
It's "<="&B12.
Hello
It's "<="&B12.
Amazing, thank you so much!
