Hi,

HELP!

Any help with this issue would be great. I'm trying to count the
number of days for a given month in a range of cells that contain
multiple months.

Example:

1/1/6
3/1/6
1/2/6
1/5/6
2/2/6
2/7/6

Answer: the number of days in January is 3, the # of days in March is
1, the number of days in February is 2.

I've tried a variety of formulas, from counti, datedif, sumif,
sumproduct, etc. and can't seem to get them to work.

Any Ideas or help would be greatly appreciated.

Thank you!


--
jr100
------------------------------------------------------------------------
jr100's Profile: http://www.excelforum.com/member.php...o&userid=31335
View this thread: http://www.excelforum.com/showthread...hreadid=510159