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

Occasional Contributor

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

@Varun_Aggarwal Try this:


The number 5 is chosen because I assumed that 5 is the day number for a Thursday.  


I'd adjust the formula as


Main question here is - if today is Thu shall we show this date or next Thu. If the latest that could be


All set of formulas for such case is here Date for Next Wednesday (Microsoft Excel) (

best response confirmed by Varun_Aggarwal (Occasional Contributor)

@Sergei Baklan 


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