Counting dates before today
 

Hi, I have a list of dates in column E4:E38 ranging from 14/2/09 to
14/4/09 some of which occur more than once. What I would like to do is
count how many occurrences there are of dates previous to and including
today including the duplicates etc. I have tried countif and counta but
dont seem to be able to get the right formula. I have (today) in A2.
Thank you for any help with this.

Counting dates before today
 

Try this:

=COUNTIF(E4:E38,"<="&TODAY())

--
Biff
Microsoft Excel MVP


"Lynz" wrote in message
...
Hi, I have a list of dates in column E4:E38 ranging from 14/2/09 to
14/4/09 some of which occur more than once. What I would like to do is
count how many occurrences there are of dates previous to and including
today including the duplicates etc. I have tried countif and counta but
dont seem to be able to get the right formula. I have (today) in A2.
Thank you for any help with this.

Counting dates before today
 

Hi,

Your formula would look like this

=COUNTIF(E4:E34,"<="&A2)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lynz" wrote:

Hi, I have a list of dates in column E4:E38 ranging from 14/2/09 to
14/4/09 some of which occur more than once. What I would like to do is
count how many occurrences there are of dates previous to and including
today including the duplicates etc. I have tried countif and counta but
dont seem to be able to get the right formula. I have (today) in A2.
Thank you for any help with this.

Counting dates before today
 

T. Valko wrote:
Try this:

=COUNTIF(E4:E38,"<="&TODAY())

THank you so much that works great. I had () and"" in the wrong places.
HAve a nice day
L

Counting dates before today
 

Shane Devenshire wrote:
Hi,

Your formula would look like this

=COUNTIF(E4:E34,"<="&A2)

Thanks Shane

Counting dates before today
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lynz" wrote in message
...
T. Valko wrote:
Try this:

=COUNTIF(E4:E38,"<="&TODAY())

THank you so much that works great. I had () and"" in the wrong places.
HAve a nice day
L

Counting dates before today
 

Hi,

Your welcome.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lynz" wrote:

Shane Devenshire wrote:
Hi,

Your formula would look like this

=COUNTIF(E4:E34,"<="&A2)

Thanks Shane