Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking by date
I created a 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tracking change time/date | Excel Worksheet Functions | |||
Tracking Date Changes | Excel Discussion (Misc queries) | |||
Tracking Change Date | Excel Worksheet Functions | |||
Can this even be done? Tracking Date / Time Elapsed | New Users to Excel | |||
Date Tracking | New Users to Excel |