how can change date regarding anothr cell

November 10, 2010 at 03:52:50
Specs: Windows XP
hi,i have an excel sheet that calculates the life cycle of a certin process,i want the date to change automatically when i change the life cycle time ,i.e,i want to fix the start date then if i enter lets say X days in a cell then the next cell must equal the fixed dat + X

See More: how can change date regarding anothr cell

Report •

#1
November 10, 2010 at 05:41:41
Something like:

       A            B             C
1) Start Date	Increment	New Date
2) 11/10/2010       10         11/20/2010

Cell A1 and C1 are formatted as DATES.

The formula for the New Date would be =A2 + B2

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question