Remember Me?

#1
June 30th 09, 09:01 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 128
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

#2
June 30th 09, 09:25 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 8,521
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

#3
June 30th 09, 09:26 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post cainart New Users to Excel 13 July 25th 07 12:50 PM Bob Excel Discussion (Misc queries) 2 April 25th 07 04:44 PM Igottabeme Excel Discussion (Misc queries) 1 April 20th 06 10:03 PM sam76210 Excel Discussion (Misc queries) 0 March 8th 06 05:05 PM Millerk Excel Discussion (Misc queries) 2 March 2nd 06 07:23 PM

All times are GMT +1. The time now is 07:16 PM.