Question on how to fill a range of dates on Excel (newer version).?

I think you will have to resort to using VBA to do as you wish as your examples do not represent date formats Excel can parse.

Here is one way to do that using a Worksheet_BeforeDoubleClick event handler. This assumes the column to contain the data is column A. If your column is not column "A", then modify the code before copying:

Change the "A:A" reference to your column letter, i.e. "C:C", "M:M", etc.

Change the "A" reference to your column letter, i.e. "C", "M", etc.

Then, copy the event handler to the clipboard (highlight the entire event handler, right click inside the highlighted area, and 'Copy'):

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Range("A:A").ClearContents

setWeeks = InputBox("Enter the number of weeks to display", "How Many?")

If setWeeks = "" Then

Target.Offset(1).Select

Exit Sub

End If

stDate = InputBox("Enter the first date, i.e. '4/24/2016", "Starting Date")

If stDate = "" Or Not IsDate(stDate) Then

Target.Offset(1).Select

Exit Sub

End If

sDate = CDate(stDate)

For i = 2 To setWeeks + 1

eDate = DateValue(sDate + 6)

Range("A" & i).Value = sDate & " - " & eDate

sDate = eDate + 1

Next i

Target.Offset(1).Select

End Sub

Select the worksheet that you wish to enter the dates into and right click the sheet tab at the bottom.

Select 'View Code'.

Paste the event handler into the white editing area to the right (right click inside the area and 'Paste').

Close the VBE (Red button - top right).

To set the dates, double click any cell in the worksheet. Enter the number of 'week periods' that you wish to enter, i.e. 10, 20, etc. and click 'OK'. Enter the starting date, i.e. 4/24/2016 and click 'OK'. That number of week dates will be returned. The dates will begin in row 2, assuming you have a column header in row 1.