need formula to kick response for X-month from cell date

L

Les B

I am trying to write a formula that will return the letters AC at 360 days
from the date of the last A/C PM. I am working with 5 sheets and the one i
want to pull from is labeled AC PM in which the date is in column E. I made
the spread sheet in Excel 97 but I am now using Excel 2003. Thanks in advance
for any help you can give me
 
F

Frank Kabel

Hi
not very clear how your data looks like and what A/C PM is?. Maybe post
an example 8plain text - no attachment please) and describe the exact
cell references and your expected result
 
L

Les B

Frank
I created this spread sheet to track the preventative maintenance (PM) on a
fleet of a little over 100 transit buses. On the first sheet named milage I
update the miles on each bus byweekly. This allowes me to track the different
PM that need to be done on the buses. It workes well by mileage on every
thing except air condishing (A/C) PM that need to be done every 12 months on
most buses and every 6 months on a few of them. On the AC PM sheet I start A2
with the bus # & B as the due milage, C is the milage pulled from sheet 1, D
is the one I am pulling from now to kick the letters AC on sheet 1, E is the
date of the last PM and I am using a (ie)11/23/2004 date format. I have tried
quit a few formulas with out sucess to do this.
Thanks in advance for any help you can give me

Les B
Las Vegas Nv
 
Top