View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eidde1@gmail.com is offline
external usenet poster
 
Posts: 21
Default Update date every two weeks when a sheet is opened

Hi

I have a date in a cell (next delivery date). We get the item every
second Tuesday. I am looking for (possibly) a function that updates
this date every time the sheet opens, so currently the next delivery
date is 05/05/09 and it will be delivered again on 19/05/09. So if the
sheet is opened on 06/05/09 the date should read 19/05/09. Is this
possible in Excel

Your help would be much appreciated.

Eddie