Request for help - COUNTIFS Formula

Bruce Venhuizen

Requesting some assistance with a COUNTIFS formula. I want to count the number of instances within a date column titled 'ACTUAL FINISH' between 1/1/23 and 3/31/23 to display a quarterly total count for Q1 using the Sheet Summary feature.

For example, there are numerous dates between 7/13/22 - 3/31/23 in my image however only '2' fall within the result range I need therefore the Sheet Summary should show the number '2' if my formula is working correctly but alas it is not.

=COUNTIFS[(ACTUAL FINSIH)] AND([DATE (ACTUAL FINISH) is between (2023,1,1:2023,3,31)

Actual Finish column screenshot.jpg

Kelly Moore

Hey @Bruce Venhuizen

=COUNTIFS([Actual Finish]:[Actual Finish], AND(@cell>=DATE(2023,1,1), @cell<=DATE(2023,3,31)))

Will this work for you?

Kelly