# 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   Register To Reply

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))  Register To Reply

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

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

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

Is there any chance to post a small example?  Register To Reply

5. ## Re: count if greater than date in cell E1.  Register To Reply

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

@fabrecass,  Register To Reply

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

here is the example   Register To Reply

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)  Register To Reply

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  Register To Reply

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)  Register To Reply

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

brilliant, thank you  Register To Reply

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

You're welcome!   Register To Reply

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