Create formula in summary to calcuate based on date

sholmes

Hi, I am trying to use formula on my sheet summary to provide me with the total documents received based on if the date received is before May 1, 2024, of this year. Anyone can help me with that?

Paul Newcome

You would use something along the lines of

=COUNTIFS([Date Received]:[Date Received], @cell< DATE(2024, 05, 01))

Paul Newcome

You would use something along the lines of

=COUNTIFS([Date Received]:[Date Received], @cell< DATE(2024, 05, 01))

sholmes

@Paul Newcome thanks so much, that seems to be working.

Paul Newcome

Happy to help. 👍️