Jun 27 2021 10:46 AM
I am having some trouble figuring out the formula to auto-populate the date of next Thursday from another cell date. Kindly refer to the attached sheet, I need to insert a formula in B2 cell.
Jun 27 2021 11:26 AM
@Varun_Aggarwal Try this:
=A2+5-WEEKDAY(A2)
The number 5 is chosen because I assumed that 5 is the day number for a Thursday.
Jun 27 2021 12:00 PM
I'd adjust the formula as
=A2+7-WEEKDAY(A2+2,1)
Main question here is - if today is Thu shall we show this date or next Thu. If the latest that could be
=A2+7-MOD(A2+2,7)
All set of formulas for such case is here Date for Next Wednesday (Microsoft Excel) (tips.net)
Jul 04 2021 11:30 AM
Solution
Thanks a lot! I was looking at the below formula and it worked pretty well.
=A2+7-WEEKDAY(A2+2,1)
Jul 04 2021 12:03 PM
@Varun_Aggarwal , you are welcome
Jul 04 2021 11:30 AM
Solution
Thanks a lot! I was looking at the below formula and it worked pretty well.
=A2+7-WEEKDAY(A2+2,1)