Last week's Thursday in formula

[waldymar]

Dear All,

can anyone suggest a dynamic formula which will show a date of last week's Thursday?
Thanks in advance!

 

[waldymar]

Biz, thanks a lot for detailed explanation! Very smart, appreciate much your help!
GTO, looks complicated)! Thanks for your time!

 

[Biz]

Biz, thanks a lot for detailed explanation! Very smart, appreciate much your help!
GTO, looks complicated)! Thanks for your time!

Thanks for feedback

 

[jasonb75]

Now() gives todays date.


Biz

That is incorrect.

NOW() returns the current date and time.

TODAY() returns the current date only.

=TODAY()-WEEKDAY(TODAY()-5)