Macro to Auto Fill Dates in Column

[erock24]

I have a startdate F1 and an end date G1. Is there a macro that can list all dates by day within that range into column I7:down. A macro solution would be ideal.

Thank you very much for your time and help.

[ExcelFed]

If you use this formula in I7 and drag down, it should work. This assumes I6 is blank

=IF(I6="",G1-(G1-F1-1),IF(I6>=$G$1,"",I6+1))

[erock24]

Thank you for the reply. The formula works. However, I incorrectly stated my needs. Turns out I need to scratch the start date, end date stuff and proceed as described below:

I need a macro that will identify the last cell in I and fill down the dates to the end of the year. For example, If the last cell in I were to be I188 and it = 6/30/2008, I need I189 to = 7/1/2008, I190 to = 7/2/2008, etc.

Is there a macro that could do this?

[VBA Noob]

This worked for me.

Note no error checking if you run it twice

Please Login or Register  to view this content.

VBA Noob

[erock24]

That works perfect thank you. I added an error feature.

Please Login or Register  to view this content.

[VBA Noob]

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

[erock24]

How could I edit the macro to only fill to the last day of the month instead of the year?

Thank you.

[erock24]

How do I make it always default to the last day of the month. Instead of having the "31" hard coded in?

Please Login or Register  to view this content.

[erock24]

I'm checking here to see: http://www.mrexcel.com/forum/showthr...08#post1816808

[erock24]

by jonmo1: http://www.mrexcel.com/forum/showthr...=1#post1816939

Please Login or Register  to view this content.

works perfect