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 |
Determining a future date, again
Maybe this
=A1+CHOOSE(WEEKDAY(A1),17,16,15,14,20,19,18) Mike "Andrew Taylor" 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 |
Determining a future date, again
many thanks
"Mike H" wrote: Maybe this =A1+CHOOSE(WEEKDAY(A1),17,16,15,14,20,19,18) Mike "Andrew Taylor" 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 |
Determining a future date, again
|
All times are GMT +1. The time now is 04:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com