I need to find the Monday or Wednesday prior to a given date minus 4 days weekdays in order to Calculate a submission date.
Examples:
I have been looking around but I can't find that fits my need. I know I need to use WEEKDAY and CHOOSE might be helpful but that is about how far I have gotten.
Examples:
- Date given is 7/31, then I want to return 7/23/18
- Date given is 7/26, then I want to return 7/18/18
- Date given is 7/25, then I want to return 7/18/18
I have been looking around but I can't find that fits my need. I know I need to use WEEKDAY and CHOOSE might be helpful but that is about how far I have gotten.