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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

-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.
 
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.
 
Back
Top