Formula to find closest Thursday to a date

floggingmolly

New Member
Joined
Sep 14, 2019
Messages
47
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

MrExcel MVP
Joined
Aug 18, 2015
Messages
8,803
Glad to help! :cool:

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.
 

Forum statistics

Threads
1,078,338
Messages
5,339,638
Members
399,317
Latest member
mLife

Some videos you may like

This Week's Hot Topics

Top