View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default Date in an excel form

Hi,

I'm creating a chart in an excel form and it has the same section 7 times
(for every day of the week)

I want it so that once the user enters the first date for Sunday. eg they
enter: 12/12/04, then all the other date fields for the rest of the week get
filled in automatically. So the date field for that Monday will be 12/13/04...

Is this possible?!?! If yes, how!