Formula to find closest Thursday to a date

[floggingmolly]

I have a sheet with a date in Column B. I need to find the closest Thursday that is 150 days prior to this date. I can't seem to get the formula to make this happen. Any help would be appreciated.

 

[Eric W]

Try:

=B2-150-WEEKDAY(B2)+1

 

[floggingmolly]

Try:

=B2-150-WEEKDAY(B2)+1

Thank you. I was making it more difficult than it was. LOL. I appreciate your help.

 

[Eric W]

Glad to help!

These date formulas can be deceptively tricky. Note that if you want to go back 160 days and find the closest Thursday, you can't just change the 150 to 160. You also need to adjust the +1 on the end. But the form of the formula should be the same.