Hi guys. First post so be gentle.
So I have a spreadsheet with load IDs on it, certain loads get done on certain days and so for example 90757 get done on Monday. So what I'm trying to do is input the load ID onto a separate sheet and reference the day on the original sheet and change it to a date based on the week commencing entered. Any help appreciated. Thanks
So I have a spreadsheet with load IDs on it, certain loads get done on certain days and so for example 90757 get done on Monday. So what I'm trying to do is input the load ID onto a separate sheet and reference the day on the original sheet and change it to a date based on the week commencing entered. Any help appreciated. Thanks