Ok so I ended up just entering the date equivalent for the week

i.e 201801 01/01/2018
column a column b

and then simply entered a vlookup in the report column, this tells me easily what week i'm looking at instead of trying to figure out which week is which date.

Really appreciate your help, step 1 is complete, the semi automatic method - next I will work on figuring out the fully automated version (in another thread maybe) and this version of the report will allow me to audit it quickly.

Thanks!! I have marked it as solved