View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Thomas Dave Thomas is offline
external usenet poster
 
Posts: 146
Default input a date or update it based on date in another cell

You don't explain how the date in c3 is affected by the change in c2. If c2
changes from 2 to 5 do you want cell c3 to be incremented by 5? or do you
want it incremented by 5-2 = 3?

Give us some before and after examples.

"Doug P" wrote in message
...
-Someone asked me to setup a spreadsheet like this

cell b2 is entered as a date
cell c2 is entered as a number
cell d2 is a calculated date =b2+c2
now cell c2 gets more interesting. the user will enter a date like they
did
in b2, but if the number in c2 is changed modifing the date in d2 they
want
the date in c3 to be advanced as well.

They want to use it to track some projects using software they have
already
paid for and not buy additional software.
--
Doug P