Which data occurred in a certain month

B

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.
 
F

Frank Kabel

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

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).
 
B

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).


.
Click to expand...
 
B

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


.
Click to expand...
 
L

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.
: >>.
: >>
: >.
: >
 
F

Frank Kabel

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