Forum Discussion

Fatih Temel's avatar
Fatih Temel
Copper Contributor
May 24, 2017
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. "<...
Formulas & Functions
tips and tricks
  • Detlef_Lewin's avatar
    Detlef_Lewin
    May 24, 2017

    Hello

     

    It's "<="&B12.

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
May 24, 2017

Hello

 

It's "<="&B12.

 

  • Fatih Temel's avatar
    Fatih Temel
    Copper Contributor
    May 24, 2017

    Amazing, thank you so much!

Resources