Autofill Dates in Excel Based on Another Cell | Increment Dates Using Formula - Days, Weeks, Years

Published: 15 March 2023
on channel: Chester Tugwell
35,757
131

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
------------------------


Watch video Autofill Dates in Excel Based on Another Cell | Increment Dates Using Formula - Days, Weeks, Years online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 15 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 35,757 once and liked it 131 people.