I think I am being extremely thick, however I am trying to work out what the
date is a week ago from today's date excluding weekends. I don't want to
know how many working days ago it was, I need to know the actual date. Does
anyone know how to do this? Help would be greatly appreciated as I'm really
scratching my head over this one.

Thanks a lot
Aehan