Download the featured file here: https://www.bluepecantraining.com/wp-...

In this Microsoft Excel video tutorial I demonstrate how to autofill dates based on a start date in another cell. You can autofill each day, working day, month or year using this technique. The first part of the video covers examples using the SEQUENCE function. The second part of the video is for those of you who don't have the SEQUENCE function and instead uses the ROW or COLUMN functions.


Table of Contents:

00:00 - Introduction
00:26 - Autofill days using SEQUENCE
02:11 - Autofill months using SEQUENCE
03:15 - Autofill years using SEQUENCE
04:39 - Autofill working days using SEQUENCE
06:27 - Autofill non-standard working days using SEQUE
08:18 - Autofill days using ROW or COLUMN
11:36 - Autofill months using ROW
12:53 - Autofill years using ROW
14:29 - Autofill working days using ROW
15:59 - Autofill non-standard working days using ROW
------------------------