View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Happy Gilmore
 
Posts: n/a
Default Set a date as a constant to work back from to show only weekdays

I would like to input one date as a constant and then apply a formaula in
other cells relating to this date to calculate back from but to "round" back
to only weekdays. For example if i type in a date of February 1st 2006 (a
Wednesday) and would like to calculate backwards automatically by eleven days
it is Sat Jan 21st 2006. I would like this to round back to the nearest
previous workday which would be the Friday.