COUNTIFS if a Date cell is within 30 Days

Richard King

Hi,

Is it possible to COUNTIFS with one of the criteria being a date that is equal to or within 30 days to that set in another cell?

In the past I have used a helper column to count the days and just count the cells that fell within the number of day <=30, <60, etc.

Any help would be much appreciated.

Thanks

Richard

Kimberly Loveless

So something like this? I am counting the number of entries that are <= 30 days from the value in Date 2 using the formula below

=COUNTIF(Date:Date, @cell <= [Date 2]1 + 30)

Prasad Kanse

Please try below formula.

=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-30)))

=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-60)))

Richard King

Hi Kimberley & Prasad,

Many thanks for the reply, both works.

Richard

Kimberly Loveless

So something like this? I am counting the number of entries that are <= 30 days from the value in Date 2 using the formula below

=COUNTIF(Date:Date, @cell <= [Date 2]1 + 30)

Prasad Kanse

Please try below formula.

=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-30)))

=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-60)))

Richard King

Hi Kimberley & Prasad,

Many thanks for the reply, both works.

Richard