sales dates

  • Thread starter Thread starter George A. Jululian
  • Start date Start date
G

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
 
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
 
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
 
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
 
Many thanks for your help and support

regards

Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
Back
Top