How do I get excel to look at sheet named "Transactions" and look down column b for any date that is a Friday and return that date, otherwise return the most recent date. The sheet is imported to it comes over as 4/17/18 with no day. Even if I format the cell to show the day, the formula wont find Friday because it technically doesn't shoe in the cell.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,589
- Office Version
- 365
- Platform
- Windows
Duplicate https://www.mrexcel.com/forum/excel-questions/1054244-date-parameters.html#post5062247
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
Upvote
0
- Status
Similar threads
- Solved
- Question
- Question
