Hi there
What I want is for the date format to be changed from dd/mm/yy 00:00:00 to dd/mm/yy which I can do with formula
but I'm not sure how to do this in code form column H
I then need to take the new date format and if that is greater than or equal to 20/01/2010 then run the formula
All in a macro.
I was trying advanced filter but I am not sure how to do this.
This code works for the full column but does not only run weekday formula for anything after 20/01/2010 plus is in wrong date format so cannot do analysis on it after.
All help gratefull recieved.
Libby
Bookmarks