Can't seem to find this anywhere and hoping it's possible. I have a report that provides a weekly order day, I am trying to convert this day into a date and can't seem to figure it out. All dates would be the next occurrence of the listed day.
| Lane | Location 1 | Go Live Cadence | PO Drop Day | Pick Day | Ship Day |
| Anchorage | D059 | Weekly | MON | TUE | WED |
| Fife | D053 | Weekly | MON | TUE | WED |
| Buford | D021 | Weekly | FRI | MON | TUE |
| Buford | D0VA | Weekly | FRI | MON | TUE |
| Dixon | D069 | Weekly | MON | TUE | WED |
| Hammond | D0VZ | Weekly | MON | TUE | WED |
| Hammond | D043 | Weekly | MON | TUE | WED |
| Montgomery | D0V2 | Weekly | MON | TUE | WED |
| Montgomery | D0OC | Weekly | MON | TUE | WED |
| Honolulu | D055 | Weekly | MON | TUE | WED |
| Ontario | D073 | Weekly | MON | TUE | WED |
| Ontario | D0EW | Weekly | MON | TUE | WED |
| Jefferson | R2JG | Weekly | MON | TUE | WED |
| Weston | D022 | Weekly | MON | TUE | WED |
| Weston | D0EM | Weekly | MON | TUE | WED |
| Waukegan | D0CG | Weekly | MON | TUE | WED |
| Allentown | D07A | Weekly | TUE | WED | THU |
| Baltimore | D0HD | Weekly | TUE | WED | THU |
| Baltimore | D0V1 | Weekly | TUE | WED | THU |
