| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Bi-weekly time sheet change dates to Thursday- Wednesday? | New Users to Excel | |||
| I want to stop the help menu poping up in excel | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Save Excel File every wednesday VB Script Help !! | Excel Discussion (Misc queries) | |||
| Determine every wednesday based off year | Excel Discussion (Misc queries) | |||
Linear Mode
