auto-calculations using calendar and dates (Excel-Office 2000)
I want to have excel calculate the last 2 columns but need help with the
formulas. My spreadsheet should show a summary of part numbers. Each part
has a service life which begins on the date of installation. I am hoping
that excel can calculate "Date to be removed" and "days to go" automatically
with insertion of a proper formula.
service life date installed date to be removed
days to go
12 months 10/26/2004 10/26/2005
280
I would appreciate help with the formula for the last two columns?
|