Forum Discussion

ExcelHALP's avatar
ExcelHALP
Copper Contributor
Jun 02, 2022

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?

 

Tuesday07/05/2022
Tuesday07/12/2022
Tuesday07/19/2022
Tuesday07/26/2022

             

Sunday07/03/2022
Thursday07/07/2022
Sunday07/10/2022
Thursday07/14/2022
Sunday07/17/2022
Thursday07/21/2022
Sunday07/24/2022
Thursday07/28/2022
Sunday07/31/2022

           

Thanks in Advance!

         

                        

Resources