To Refer particular Month in large datas
 

I having large date in one Column with different dates in data
Format(mm/dd/yyyy). I want to refer how many datas in particular month

To Refer particular Month in large datas
 

As long as its real dates, whatever date-format subsequently applied doesn't
matter

This will count all dates in col A which are in Feb 2008:
=SUMPRODUCT(--(TEXT(A2:A1000,"mmm yyyy")="Feb 2008"))

And this will sum col B for all dates in col A which are in Feb 2008:
=SUMPRODUCT(--(TEXT(A2:A1000,"mmm yyyy")="Feb 2008"),B2:B1000)

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"PERANISH" wrote:
I having large date in one Column with different dates in data
Format(mm/dd/yyyy). I want to refer how many datas in particular month

To Refer particular Month in large datas
 

If you really don't care about year, as your post says nothing about that, then

=SUMPRODUCT(--(MONTH(A1:A20)=1))

Would count the number of January dates in the range, if you do care about
year then you could use

=SUMPRODUCT(--(A1:A20=C1),--(A1:A20<=C2))

Where you enter the first day of the month in question in C1 as a date, and
the ending date of that month in C2.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"PERANISH" wrote:

I having large date in one Column with different dates in data
Format(mm/dd/yyyy). I want to refer how many datas in particular month