Formula

hello1030

Hello, I have a tracker that has columns Customer, Completion Date, and Status.

I would like to count the number of customers where the completion date is between 4/1/2024 and 4/30/2024 and when Status says In Progress. How do I write this out? Thank you in advance for your help!

heyjay

=countifs(
[Completion Date]:[Completion Date], >=DATE(2024,4,1),
[Completion Date]:[Completion Date],<=DATE(2024,4,30),
Status:Status,"In Progress")

hello1030

Thank you. It is showing #UNPARSEABLE

heyjay

This one is working for me, can you double check your date columns if they are actual date in the properties. and the column name matches what we have in the formula.