View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How to set formula for poping up the date of next Wednesday....

In A2
=A1+(IF(WEEKDAY(A1)=4,7,0)-WEEKDAY(A1))+4

If this post helps click Yes
---------------
Jacob Skaria


"J" wrote:

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