View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Taylor[_2_] Andrew Taylor[_2_] is offline
external usenet poster
 
Posts: 1
Default Determining a future date, again

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