Autofill Dates in Excel Based on Another Cell | Increment Dates Using Formula - Days, Weeks, Years
Vložit
- čas přidán 5. 08. 2024
- Download the featured file here: 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
------------------------ - Jak na to + styl
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.
thanks chester, very useful tutorial!
Great tutorial Chester. A complete detailed video, with practical explanations and recurring cases on a day-to-day basis with the tool. Thank you!!!
Glad you enjoyed it!
@@ChesterTugwell , please what formula can I use to increase the total amount of first column and decrease the total amount of the second column
Thanks a lot. Great video
You are welcome!
❤️❤️❤️
👏👏
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.
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.
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.
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
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.
EG: i.imgur.com/OIEpAiJ.png
Any help?