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

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

How to set formula for poping up the date of next Wednesday....
 

Try this

=A1+7-WEEKDAY(A1+3)

Mike

"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