fill range with dates based on month

F

flyinghigher2011

hi all

i have a cell N3 where i put lets say Aug13 and i have cell tha
hopefully put in 1 aug 2013, what im after is this.

if N3 is August or aug13 then i need either 29 or 30 rows created an
filled with the number of days in the month, the reason for this is tha
there are 30 or 31 days in a month as you know.

is this possible?

ive attached a workbook for consideration

+-------------------------------------------------------------------
|Filename: Book1.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=894
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

frustraded with conditional values return in a range of dates 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
Help with determining # of days from certain dates 2
sumproduct with COUNTIF With An INDIRECT 1
Using if and and for an email tracker 3
Need help with average/lookup formula 2
calculate last 4 data points in a column (with sometimes blank rows) 7
If Formula and Dates 4

Top