Forum Discussion
ExcelHALP
Jun 02, 2022Copper Contributor
Calculating Next Months Date for Specific Days of the Week
Hello!
First time here hopefully I am on the right board.
I want to figure out a formula to calculate the next month's date for a certain day of the week on column B.
Example - These are all Tuesdays in July, I want to add to this column/ create a formula that would calculate Tuesdays in August.
I cannot do a fill series as I am working with a template that may have multiple set of weekdays for the month.
Any Macros that would also help?
Tuesday | 07/05/2022 |
Tuesday | 07/12/2022 |
Tuesday | 07/19/2022 |
Tuesday | 07/26/2022 |
Sunday | 07/03/2022 |
Thursday | 07/07/2022 |
Sunday | 07/10/2022 |
Thursday | 07/14/2022 |
Sunday | 07/17/2022 |
Thursday | 07/21/2022 |
Sunday | 07/24/2022 |
Thursday | 07/28/2022 |
Sunday | 07/31/2022 |
Thanks in Advance!
- tauqeeracmaSteel Contributor
Hi ExcelHALP
With the help of a few helper columns and a couple of excel formulas, you can find the date of a certain day in the next month.
Please refer to the attached sample file.
I hope it will help, please let me know if it works for you.
Thanks
Tauqeer