Thread: Get next THU date based on date entered in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default Get next THU date based on date entered in another cell
=D4+8-WEEKDAY(D4+3)

--


Regards,


Peo Sjoblom

"Munchkin" wrote in message
...
I want K4 to enter next Thursday's date based on the date entered in D4.

How do I do that?




Reply With QuoteReply With Quote