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.
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
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.
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?
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!
❤️❤️❤️
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
👏👏
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.
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.
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?