Folks,
I'm a few weeks now at trying to crack this issue and have made promising progress a few times until it inevitably falls down. I've been messing around with worksheet based solutions like Leila Gharani has (
) and another on ExcelJet (Excel formula: Get nth day of week in month | Exceljet) but can't put it all together to get what I want.
What I have is a userform that has text boxes for a start date, an end date and three boxes for recurring weeks. What I would like is for the user to be able to enter a start date (that corresponds with the recurring day of the week) and an end date. Then choose which weeks they want a file saved for i.e. 1st, 3rd & 5th Tuesday of the month. Then the excel gods take over and a copy is saved with a filename that matches with the dates. i.e. in January 2021, we would get a files dated the 05-01-21 & 19-01-21, the first and third Tuesdays.
I can't find a way to correctly identify the weeks that need to be saved.
Any help or suggestions would be greatly appreciated.
Many thanks in advance,
Dave
I'm a few weeks now at trying to crack this issue and have made promising progress a few times until it inevitably falls down. I've been messing around with worksheet based solutions like Leila Gharani has (
What I have is a userform that has text boxes for a start date, an end date and three boxes for recurring weeks. What I would like is for the user to be able to enter a start date (that corresponds with the recurring day of the week) and an end date. Then choose which weeks they want a file saved for i.e. 1st, 3rd & 5th Tuesday of the month. Then the excel gods take over and a copy is saved with a filename that matches with the dates. i.e. in January 2021, we would get a files dated the 05-01-21 & 19-01-21, the first and third Tuesdays.
I can't find a way to correctly identify the weeks that need to be saved.
Any help or suggestions would be greatly appreciated.
Many thanks in advance,
Dave
