View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j j is offline
external usenet poster
 
Posts: 128
Default How to set formula for poping up the date of next Wednesday....

I would like to know how I can set a formula which shows that date of next
wednesday.....

e.g today is 2009/07/01 (A1)
how can the cell will pop the value of '2009/07/08' in cell A2?
p.s the value of in cell A2 depends the date of today (A1)....
i.e. if today is 2009/08/07 (A1)... the cell in A2 will pop up as 2009/08/12
--
J