ExcelBanter - Get next THU date based on date entered in another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Get next THU date based on date entered in another cell (https://www.excelbanter.com/excel-worksheet-functions/204883-get-next-thu-date-based-date-entered-another-cell.html)

munchkin

Get next THU date based on date entered in another cell

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

How do I do that?

Peo Sjoblom[_2_]

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?

All times are GMT +1. The time now is 05:31 AM.