ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   fill range with dates based on month (https://www.excelbanter.com/new-users-excel/449076-fill-range-dates-based-month.html)

flyinghigher2011 July 31st 13 06:40 PM

fill range with dates based on month
1 Attachment(s)
hi all

i have a cell N3 where i put lets say Aug13 and i have cell that 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 and filled with the number of days in the month, the reason for this is that there are 30 or 31 days in a month as you know.

is this possible?

ive attached a workbook for consideration.

All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.