Need help with Countifs formula

Melissa Lee

Hi. Can you help me with this formula?

Essentially I want to count the number of positions that have the criteria "Filled" in one column, but also have to have the date 04/17/20 in another column. This formula is not working and I have changed slight variations with commas, "=" and parenthesis and can not make it work. Can you help?

=COUNTIFS({DT Headcount FY21 Range 2},="Filled",{DT Headcount FY21 Range 3},"04/17/20"})

Leibel S

@Melissa Lee

Try the below using the date function

=COUNTIFS({DT Headcount FY21 Range 2},"Filled",{DT Headcount FY21 Range 3},DATE(2020, 4, 17))

Leibel S

@Melissa Lee

Try the below using the date function

=COUNTIFS({DT Headcount FY21 Range 2},"Filled",{DT Headcount FY21 Range 3},DATE(2020, 4, 17))

Melissa Lee

It worked! Thank you so much. I didn't realize I had to break the date out like that. Thank you.