View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pendelfin Pendelfin is offline
external usenet poster
 
Posts: 21
Default date to show then end of the week

Hi

I am trying to carryout some calcualtions on dates to show the day before
the next working day.

Is there a formula I can use so for example if the date is Friday 3 January
2009 it will show Sunday 5 January - or alternativly if easter weekend the
last working day would be Thursday 8 April 2009 so the date shown would be
Monday 12 April 2009?

Many thanks in advance for your help