Forum Discussion

itsmatta's avatar
itsmatta
Copper Contributor
Jun 10, 2024
Solved

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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

Resources