Date Formula Help to auto populate next day of the week's date

Hello excel experts.

I'm looking for a date formula to auto populate a cell with next Thursday's date. For example, If today is Thursday use today. If today is GT Thursday use next Thursday's date. This is what I have so far, which seems to work for today but not sure if it's correct: =TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>3,10,3)

This code works to auto populate next Friday's date: =TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>4,11,4)

I also need code for Next Saturday, Sunday, and Monday's dates so if someone can help translating this code into English so I can understand it better it would be greatly appreciated

Thanks!!!

s.

Your first version was almost correct, Martin. Try

=TODAY()+7-WEEKDAY(TODAY()-5)

5 for Thursday, change as required - 1= Sun through to 7=Sat

The first formula was correct: (in the USA)

Please Login or Register  to view this content.

In ISO-countries:

Please Login or Register  to view this content.

Hello snb, perhaps I'm misunderstanding the requirement (what is "GT Thursday"?) but that won't give today's date if today is Thursday, which is what symaxf says he wants (it'll give the following Thursday)

My suggested formula gives the current date on a Thursday, otherwise it gives the next Thursday after that date

I think you are right and I misread the requirements.
I read it as: 'next week's thursday'.