# count if greater than date in cell E1.

1. ## count if greater than date in cell E1.

hi
i would like 3 formulas for countif
i would like to count all cells that contain a date in column A that is more than 30 days past the date in cell E1. i would also like to count all cells that contain a date in column A that is more than 3 days past the date in cell E1 (includes those over 30 days). i would then like to count all cells that contain a date 0-3 days more than the date in cell E1.
thank you

2. ## Re: count if greater than date in cell E1.

Try 3 below formula:
=COUNTIF(A:A,">"&(E1+30))
=COUNTIF(A:A,">"&(E1+3))
=COUNTIFS(A1:A4,">="&E1,A1:A4,"<="&(E1+3))

3. ## Re: count if greater than date in cell E1.

hi, thank you, for some reason it is bringing back a 0 value though??

4. ## Re: count if greater than date in cell E1.

Is there any chance to post a small example?

@fabrecass,

7. ## Re: count if greater than date in cell E1.

here is the example

8. ## Re: count if greater than date in cell E1.

Originally Posted by bebo021999
Try 3 below formula:
=COUNTIF(A:A,">"&(E1+30))
=COUNTIF(A:A,">"&(E1+3))
=COUNTIFS(A1:A4,">="&E1,A1:A4,"<="&(E1+3))
Originally Posted by ea223
here is the example
The formulas that bebo021999 posted will do what you want.

In your sample file there are no dates that meet the first two conditions.

The formula for the third condition just needs to have the range address expanded:

=COUNTIFS(A:A,">="&E1,A:A,"<="&E1+3)

9. ## Re: count if greater than date in cell E1.

Hi, ok I see what I have got confused here. I meant to say OLDER than the date in cell e1 not past!! so it would be more than 30 days prior to the date in E1. Very sorry for this confusion, I will try the formula with a - instead of a +?
thanks

10. ## Re: count if greater than date in cell E1.

Ok, for dates OLDER than, try these:

=COUNTIF(A:A,"<"&E1-30)

=COUNTIF(A:A,"<"&E1-3)

=COUNTIFS(A:A,">="&E1-3,A:A,"<="&E1)

11. ## Re: count if greater than date in cell E1.

brilliant, thank you

12. ## Re: count if greater than date in cell E1.

You're welcome!

There are currently 1 users browsing this thread. (0 members and 1 guests)