LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 31st 13, 06:40 PM
Junior Member
First recorded activity by ExcelBanter: Jul 2013
Posts: 2
Default fill range with dates based on month

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.
Attached Files
File Type: zip (8.4 KB, 62 views)

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate Revenue based on dates within a month Annie Excel Worksheet Functions 4 July 29th 09 10:05 PM
Method to get dates based on Month [email protected] Excel Programming 2 February 23rd 07 01:25 AM
Return dates based on month and day of week lesg46 Excel Worksheet Functions 8 January 4th 07 01:47 AM
Fill column with dates of month depending on month in A1 [email protected] Excel Programming 7 March 11th 05 01:41 AM
How can i filter dates based on day of month Saurabh Excel Worksheet Functions 1 December 12th 04 06:36 PM

All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017