View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Doug P Doug P is offline
external usenet poster
 
Posts: 1
Default 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