Forum Discussion
Solved
Excel formula to get next thursday date from a cell date (or from today)
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.
Thanks a lot! I was looking at the below formula and it worked pretty well.
=A2+7-WEEKDAY(A2+2,1)
Thanks a lot! I was looking at the below formula and it worked pretty well.
=A2+7-WEEKDAY(A2+2,1)
Varun_Aggarwal , you are welcome