Excel 2007 : By selecting a month in a cell, want to list out full dates in the subsequent cells.

Hi,

Thanks in advance for your timely reply fnds...!!!

Am just new to this forum, hope i'll get some timely assistance from you guys...

Q : If i select a month from pull down in a cell, subsequently excel has to display no. of dates available in that month.

Eg: If i select feb 2012, subsequent cells has to display dates starting from 2/1/12........and end with 2/29/12 on the next cell i need total.
If i select mar 2012, subsequent cells has to display dates starting from 3/1/12........and end with 3/31/12 on the next cell i need total.


Regards,

Ram

Can you upload example workbook?

Thanks..!!! PFA..

Do you mind to have one or two empty rows in some monthes (that are <>31 days)

Not an issue now its working, Thank you... You are really asum... I have been trying to catch up with this for the past couple of days....

Will you pls, post me how to count no. of sundays in this attachment..


Ram

try this, comfirmed witrh ctrl+shift+enter (if you get 0 try again ):

=SUM(--(IFERROR(WEEKDAY(A14:A44,2),0)=7))

Or, easier, to cound Sunday text in B column:

=COUNTIF(B14:B44, "Sunday")

Thank you Zbor... Second one works exactly.....