Which data occurred in a certain month

[Brandy]

I have a list of events over a period of time and want to
know which ones occurred in the month of July only. Any
ideas?

Thanks.

 

[Frank Kabel]

Hi
if you have stored the date values in column A try
=SUMPRODUCT(--(MONTH(A1:A100)=7),--(YEAR(A1:A100)=2004))

 

[Guest]

Autofilter with a date range Custom criterion in the date
field such as ">30 Jun 04 and <1 Aug 04" (no quotes in
the criterion field).

 

[Brandy]

This didn't work ... any other ideas?

-----Original Message-----
Autofilter with a date range Custom criterion in the date
field such as ">30 Jun 04 and <1 Aug 04" (no quotes in
the criterion field).


.

 

[Brandy]

This didn't work. Any other ideas?

-----Original Message-----
Hi
if you have stored the date values in column A try
=SUMPRODUCT(--(MONTH(A1:A100)=7),--(YEAR(A1:A100)=2004))

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Lady Layla]

If that did not work, then there may be a problem with your data and how it is
entered.

Try sorting by date

Give us a written example of how your date data is entered



: This didn't work ... any other ideas?
: >-----Original Message-----
: >Autofilter with a date range Custom criterion in the date
: >field such as ">30 Jun 04 and <1 Aug 04" (no quotes in
: >the criterion field).
: >
: >
: >>-----Original Message-----
: >>I have a list of events over a period of time and want
: to
: >>know which ones occurred in the month of July only. Any
: >>ideas?
: >>
: >>Thanks.
: >>.
: >>
: >.
: >

 

[Frank Kabel]

Hi
have you real Excel date values ion column A. Also please be more
precise. What does 'does not work' mean?