Hi There Luke M
Just to inform you I will not be able to post the Macro I have used Because it does not work. When I went into it a day later all the dates had updated to that day's date (22/9/12) and today it has updated again to (23/9/12) So it does not fit the purpose and anyway I do not really care for Macro's I much prefer a straight forward Formula.Anyway it was worth a try.
Mike
Just to inform you I will not be able to post the Macro I have used Because it does not work. When I went into it a day later all the dates had updated to that day's date (22/9/12) and today it has updated again to (23/9/12) So it does not fit the purpose and anyway I do not really care for Macro's I much prefer a straight forward Formula.Anyway it was worth a try.
Mike