LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Sally from Chatham
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display dates from an Excel spreadsheet in a calendar? kescheu Excel Worksheet Functions 0 February 15th 05 08:45 PM
Outlook 2003 calendar events into Excel 2003? Kolin Tregaskes Excel Discussion (Misc queries) 4 January 31st 05 07:30 AM
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 02:41 AM
have dates entered from a list of data into an excel template Diane Excel Discussion (Misc queries) 1 December 28th 04 06:33 PM
Linking dates with a calendar... mcboots Excel Worksheet Functions 2 November 17th 04 04:11 AM


All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"