sales dates

[George A. Jululian]

i need your on this

I have one coloum fill of sales dates figures from year 1999 till 2007

I need formula to give sales figures form month August 2004 or April 2002

date formated 8/19/1999

Regards

 

[Don Guillett]

Tell us your layout and give examples

 

[George A. Jululian]

Hi,

Delivered date Year
30-Dec-01 2001
30-Nov-00 2000
22-Nov-02 2002
22-Aug-02 2002
30-Jul-00 2000
30-Nov-00 2000
21-Aug-02 2002
11-Jan-08 2008
21-Oct-07 2007

I need formaula to give all sales figures month august in year 2002

 

[Pete_UK]

Which column is your sales figures in? These are just dates.

Pete

 

[George A. Jululian]

Hi

column delivery date is sales of the month

i want to find out how sales been made on august 2001 or sales been made on
september 2005

regards

 

[Rick Rothstein \(MVP - VB\)]

Are you looking for this kind of solution? Assume Column A has your dates as
real date values and not as text values. In B1 put the **number** for the
month you want to search for and in B2 put the year number. This formula
will give you a **count** of how many dates in Column A meet your month/year
requirement...

=SUMPRODUCT((MONTH(A1:A1000)=B1)*(YEAR(A1:A1000)=B2))

Rick

 

[George A. Jululian]

Many thanks for your help and support

regards

Are you looking for this kind of solution? Assume Column A has your dates as
real date values and not as text values. In B1 put the **number** for the
month you want to search for and in B2 put the year number. This formula
will give you a **count** of how many dates in Column A meet your month/year
requirement...

=SUMPRODUCT((MONTH(A1:A1000)=B1)*(YEAR(A1:A1000)=B2))

Rick