I have a list with delivery times from a supplier where i have fixed shipment days (Tuesday and Friday) every week.
in my data set i often have all kinds of dates (different week days)
does anyone know a formula where i can round down a certain date to either the closest Tuesday or Friday.
e.g:
- delivery date Wednesday Thursday need to be rounded down to Tuesday (same week)
- Delivery date Monday needs to be rounded down to Friday (the week before)
- If the delivery date is already a Tuesday or a Friday i just need to keep that date.
any help would be highly appreciated.
Bookmarks