Referencing load IDs to days and then changing days to dates

[musicmstr]

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

 

[Skybluekid]

How is the day entered on the original sheet? Is it text or date?

Are you able share the orginal sheet and expected results.

 

[musicmstr]

How is the day entered on the original sheet? Is it text or date?

Are you able share the orginal sheet and expected results.

Thanks for your quick reply but with a bit of messing I figured it out. Thank you