Information and Communication Technology

5.4.27 Filling Dates

1. Change the format of the cells to date format.
2. Type the starting date and block the cells
3. Select Fill option in Edit menu and select Series
4. Choose fill type as Date and also choose Date unit as Day, weekday, month, year and give step value

Note:

Day Date Unit adds the step value to day of the given date

Weekday unit adds the step value only to the weekdays

Month unit adds the step value to month

Year unit adds the step value to year