SOLVED

# Excel formula to get next thursday date from a cell date (or from today)

Occasional Contributor

# 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.

4 Replies

# Re: Excel formula to get next thursday date from a cell date (or from today)

@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.

# Re: Excel formula to get next thursday date from a cell date (or from today)

``=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)

best response confirmed by Varun_Aggarwal (Occasional Contributor)
Solution

# Re: Excel formula to get next thursday date from a cell date (or from today)

Thanks a lot! I was looking at the below formula and it worked pretty well.

=A2+7-WEEKDAY(A2+2,1)

# Re: Excel formula to get next thursday date from a cell date (or from today)

@Varun_Aggarwal , you are welcome