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

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

[IvanCortinas_ES]

Great tutorial Chester. A complete detailed video, with practical explanations and recurring cases on a day-to-day basis with the tool. Thank you!!!

[hjwkxpk]

thanks chester, very useful tutorial!

[katherinetroche]

You just saved me weeks of research 😅. Been looking for exactly this for a couple of weeks now to create a data merge for my planner. Tyvm much appreciated your time. Now if you have a video for time that would complete my search.

[skiidzman]

Hi Chester, easy sub and potential donation if you can help - how do I auto-populate dates going backwards? Let's say I have a due date, 4/25/2023, and I want to simply plug in 4/25/2023 into my "Due Date" column per assignment, and it project backwards - 3 days to a "Due to Manager" column, and - 5 days to a "Due for Review" column, all while excluding weekends? This would allow me to know that 5 days before my due date, my assignment is due for review, and 3 days before my due date, it is due to my manager if that makes sense.

[filbertfox]

Hi, I have a monthly rota with separate sheets for each month. Across the columns at the top are the days of the week i.e. MON, TUE, WED including SAT, SUN etc. is it possible to have a date on each sheet i.e. 1/1/25, the first starting on a WED and all the other days of the week automatically change. Then next year all I need to do is change the 25 to 26 and the 1 of Jan is now a THU

[evanyoung]

Is there a way to return the data with empty cells between them? For example, A1 is the start date, then A5 is the next date, then A9 is the following date.

[vickiebenniefield]

Can you do a time stamp on when any cells in a row change with a vba code. You did one with just one column onlu.

[carolinebejeno]

how about the start date is 16th not first of the month? can you do an example of recurring date every 16th of the month? thanks

[Justrandom-qgec]

Hello, i have a shipping/sending book - So im trying to do this:

When i type i a date in column G i want: H(7 days), I(14 days) and J(28 days) to automatically calculate this when enter a date in G.

I got only this: =G837+7, =G837+14, =G837+28
It works but i want it automatic so i dont have to type it in every time.


Any help?