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

J

J

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
 
M

Mike H

Try this

=A1+7-WEEKDAY(A1+3)

Mike

J said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i set a formula which shows 2nd last Monday of the month? 5
VBA Coding Help for Beginner 0
Count based on date criteria 1
IF statement with 2 logicals 1
Create a chart of totals over time? 1
Date lists 3
Allocate an income payment over a date range (tax years) 7
Help with year to date comparison 4

Top