Formula for calculating dates

Hello all-I hope this is fairly simple for all of you Excel wizzes!  I am looking for a formula that when I enter a date into the cell, it will calculate 9in a different cell) the timeline.  For exam...