Great tutorial Chester. A complete detailed video, with practical explanations and recurring cases on a day-to-day basis with the tool. Thank you!!!
@ChesterTugwell
Жыл бұрын
Glad you enjoyed it!
@abdullahiashiruabdullahi3441
Жыл бұрын
@@ChesterTugwell , please what formula can I use to increase the total amount of first column and decrease the total amount of the second column
@redhaakhund1271
Жыл бұрын
Thanks a lot. Great video
@ChesterTugwell
Жыл бұрын
You are welcome!
@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.
@vickiebenniefield3218
Жыл бұрын
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.
@Samu-gz3qj
4 ай бұрын
❤️❤️❤️
@filbertfox887
Ай бұрын
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
@Justrandom1234-qg2ec
Жыл бұрын
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?
@evanyoung2818
7 ай бұрын
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.
@carolinebejeno3301
Жыл бұрын
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
@katherinetroche8812
Жыл бұрын
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.
Пікірлер: 16