Display all dates for given month

[Tha-G]

Hi,

I'm looking for a formula,

Given
cell B1: MONTH (ex. October)
cell C1: YEAR (ex. 2010)

Example Solution,
Cell B5: 01-Oct-2010
Cell B6: 02-Oct-2010
Cell B7: 03-Oct-2010
...
Cell B33: 29-Oct-2010
Cell B34: 30-Oct-2010
Cell B35: 31-Oct-2010

Remark
When the given month doesn't has 31 days it should give me in cell B35 Blank.
When the given month doesn't has 30 days it should give me in cell B34 Blank as well. (ex february).
When the given month doesn't has 29 days it should give me in cell B33 Blank as well. (ex february).

So if in example the given month is November, it should only give me the dates until cell B34 with 30-Nov-2010 and a blank field in B35.


Is there any way to fix this?

Looking forward to hear from you!

Thanks.

Best regards,

G

[daddylonglegs]

Try this formula in B5

=IF(ISERR((ROWS(B$5:B5)&B$1&C$1)+0),"",(ROWS(B$5:B5)&B$1&C$1)+0)

format in required date format and copy down to B35

[Tha-G]

Thanks! It worked

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save