Forum Discussion

itsmatta's avatar
itsmatta
Copper Contributor
Jun 10, 2024

Countif Date

I can get the formula to work if I manually type in the date. However, with data validation, I have a dropdown list of the first day of the month. So, since it's June, it says 06/01/24, and the cell ...
Excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 10, 2024

    itsmatta 

    Perhaps

    =COUNTIFS(T_LEAVE[START DATE],">=" & A1,T_LEAVE[START DATE],"<=" & EOMONTH(A1,0) )

    if drop-down with first date of months in A1

Steve_SumProductCom's avatar
Steve_SumProductCom
Iron Contributor
Jun 10, 2024

itsmatta You can concatenate the cell reference to the criteria, like below.  This assumes that E5 has the first day of the month, and F5 has the last day of the month.

 

=COUNTIFS(T_LEAVE[START DATE],">=" & E5,T_LEAVE[START DATE],"<=" & F5)

 

 

 

  • Steve_SumProductCom's avatar
    Steve_SumProductCom
    Iron Contributor
    Jun 10, 2024
    Haha. Sergei beat me to the answer.
    • itsmatta's avatar
      itsmatta
      Copper Contributor
      Jun 10, 2024
      I was on the right track, but couldn't for reason figure out why I couldn't get it to work. Appreciate you both! Thank you!

Resources