COUNTIFs Data range formula

Mo.AlAzzupary

Hi,

I am trying to generate a column wherein it would count 1 if today() falls under the range ( Start date and end date). I am always getting 0 and I have no idea why,

Thanks

Paul Newcome

You have it backwards. Try saying Start is LESS THAN today and Finish is GREATER THAN today.

=COUNTIFS([Start Date]@row <= TODAY(), [End Date]@row >= TODAY())