Thread
:
Determining a future date, again
View Single Post
#
4
Posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
Posts: 5,651
Determining a future date, again
On Wed, 19 Nov 2008 06:51:01 -0800, Andrew Taylor <Andrew
wrote:
I have a date in A1, I would like the date in A2 to be the Wednesdaythat
falls after two weeks,
for example If i enter 10/11/2008 (11/10/08 for US) I would like it to
automatically display 26/11/2008 (11/26/08 US)
I've been playing around with formulas, but not having much joy.
Andrew
I guess one question is what do you want to have happen if two weeks from today
IS a Wednesday. If, as you write, you want it to be the Wednesday AFTER, then:
=A1+22-WEEKDAY(A1+4)
If you want it to be the same Wednesday, then:
=A1+21-WEEKDAY(A1+3)
--ron
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld