View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Calculate a date

Could you give an example?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"aehan" wrote in message
...
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