Fills the selected range of cells in the spreadsheet with a series of numbers, characters, or dates. The content of the first cell in the selected range is used as the starting value for the series.
In the Fill series dialog box you enter:
Example for dates:
First enter a date in the spreadsheet and select the range for the series
Select Fill series in the menu (or press Ctrl+L) and complete the dialog box:
This is the result: