Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 30th 09, 09:01 AM posted to microsoft.public.excel.worksheet.functions
j j is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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

  #2   Report Post  
Old 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
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

  #3   Report Post  
Old 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
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Bi-weekly time sheet change dates to Thursday- Wednesday? cainart New Users to Excel 13 July 25th 07 12:50 PM
I want to stop the help menu poping up in excel Bob Excel Discussion (Misc queries) 2 April 25th 07 04:44 PM
Formula for determining if two date columns fall within specific date range Igottabeme Excel Discussion (Misc queries) 1 April 20th 06 10:03 PM
Save Excel File every wednesday VB Script Help !! sam76210 Excel Discussion (Misc queries) 0 March 8th 06 04:05 PM
Determine every wednesday based off year Millerk Excel Discussion (Misc queries) 2 March 2nd 06 06:23 PM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017