input a date or update it based on date in another cell
 

-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

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