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
|