Count date cells meeting a date condition

Question

Level 1

5 points

Count date cells meeting a date condition

Hello! I'm a 20-year Numbers for Mac user but this simple need has me stumped.

I have a column of date-formatted cells in Numbers, and I want to create a cell that shows the count of how many of those dates are one year or less in the past from today's date.

In other words, a cell that shows how many of the rows have a date from within the past year.

I can't work out whether to use COUNTIFS, COUNTIF or what.

Many thanks in advance for any help.

Mac mini 2018 or later

Posted on Dec 30, 2022 3:14 PM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,550 points

Dec 30, 2022 9:10 PM in response to Reason

One way is to do something like this:

In the example row 7 is defined as a Footer Row.

The formula in A7 is:

=COUNTIF(A,">"&EDATE(TODAY(),−12))

Replace the , in the formula with ; if your region uses , as a decimal separator.

More and EDATE here:

EDATE - Apple Support

SG

Reply

Answer 2

Reason Author

Level 1

5 points

Dec 31, 2022 6:04 AM in response to SGIII

This worked perfectly! And thanks for showing me a function I never knew existed -- EDATE!

Many thanks!

Reply

Count date cells meeting a date condition

Similar questions