Autofill between dates in Fiscal Month

  • Thread starter Thread starter akid12
  • Start date Start date
A

akid12

I am trying to autofill a column in a spreadsheet based on the dates in
a fiscal month. Basically, I want the user to enter the starting and
ending dates of the fiscal month, then have the dates autofill on a
seperate spreadsheet. The problem is that certain months do not fall in
a cosecutive range. For example, June starts on May 29 (sun) and ends
on Sat June 25th. I want the autofill to start with 29 and go to 31
then start up with 1 and fill to 25, any ideas?
 
This could be probably be done with formulas, but the specified start and
end dates must remain available for that sheet, or the formulas will change
their results. I suspect that doesn't meet your requirements. A macro
could easily fill in the sheet with dates that will stick. Are you willing
to try a macro if we write you one?

Or you can do it manually quite easily. Enter the first date, then drag the
Fill Handle down until you've reached the desired end date. It will cross
month boundaries effortlessly.
 
one way
Sub filldowndates()
Application.ScreenUpdating = False
bd = InputBox("Enter start date")
ed = InputBox("Enter stop date")
With Sheets("sheet10")
..Cells(1, 1) = bd
For i = 2 To DateDiff("d", bd, ed)
..Cells(i, 1) = .Cells(i - 1, 1) + 1
Next i
End With
Application.ScreenUpdating = True
End Sub
 
A macro would be fine, I will try the other solutions as well,
unfortunately, manual fill is not an option as the sheet is being
designed for simple data entry by non experienced excel users....Thanks
for your help
 
Back
Top