View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j j is offline
external usenet poster
 
Posts: 128
Default Function to set Date

Hi,

I would like to know how to set below equation:-

to set the 1-week (i.e Monday) prior to a specific date: e.g. 2009/11/24, i
would like to have the output = 2009/11/16

e.g. 2009/12/31, output = 2009/12/21
--
J