Example Spreadsheet:
Cell F1 is a variable day, typed in by the user (the day a product has been ordered) e.g. SATURDAY
Column A is a list of static suppliers e.g. TESCO, SAINSBURY'S etc
Columns B, C & D indicate static delivery days for each store e.g B1 = MONDAY C1 = TUESDAY D1 = THURSDAY
I would like to put a formula into column E that looks at the 'order day' in F1, and returns the number of days until the next supplier delivery is due.
Any help would be fantastic
Thanks!
Cell F1 is a variable day, typed in by the user (the day a product has been ordered) e.g. SATURDAY
Column A is a list of static suppliers e.g. TESCO, SAINSBURY'S etc
Columns B, C & D indicate static delivery days for each store e.g B1 = MONDAY C1 = TUESDAY D1 = THURSDAY
I would like to put a formula into column E that looks at the 'order day' in F1, and returns the number of days until the next supplier delivery is due.
Any help would be fantastic
Thanks!