I am using Excel to create a work scheduler that I want to automate as much as possible. I have a row of dates representing each day of the week with the current dates. So it would be a row with Monday through Sunday, each in its own column with the corresponding date in the row beneath, in mm/dd/yyyy format. I already have set Tuesday's date =B7+1, Wed date =B7+2...through to Sunday so that I only need to change the date for Monday and the rest of the dates change automatically.
I want create function to automate the process of going to the next week and assign that function to a button userform. The button would add 7 days to Mondays date;it would change 10/18/2002 to 10/25/2002.
Thanks in advance for any reply.
This is a great forum
Steve
I want create function to automate the process of going to the next week and assign that function to a button userform. The button would add 7 days to Mondays date;it would change 10/18/2002 to 10/25/2002.
Thanks in advance for any reply.
This is a great forum
Steve