![car maintenance checklist spreadsheet car maintenance checklist spreadsheet](https://db-excel.com/wp-content/uploads/2019/01/planned-preventative-maintenance-spreadsheet-for-preventive-maintenance-spreadsheet-schedule-template-excel-free-1-970x970.jpg)
If I bought the car new I'd have done the same for all the other services.
![car maintenance checklist spreadsheet car maintenance checklist spreadsheet](https://db-excel.com/wp-content/uploads/2019/01/car-maintenance-checklist-spreadsheet-throughout-vehicle-service-checklist-template-vehicle-maintenance-checklist-970x970.jpg)
Those baseline dates are the top two service entries and are just the in-service dates to start the clock. Since I haven't yet reached the first interval for Drive Belt, PDK or AWD/Diff services (6 and 12 years) I made a baseline date so the formulas didn't return an error.That plus I don't know how to do an either/or in excel yet! Since I don't DD my car I have only created due dates based of of years of service, not mileage.If it's due or overdue conditional formatting makes the date red If a service is due within 30 days, conditional formatting makes it yellow.Then adds the correct service interval in the "Due" section. It puts that date in the accomplished section. To figure out when the last service was accomplished it looks in the appropriate column, down until the latest "YES" value, then back to the left to find the date of service. I'm not a huge excel expert so the formulas I used was a simple LOOKUP. The spreadsheet has to be filled out in ascending chronological order (earliest on top).Feel free to add or delete, you can probably figure out what values need to change based on Cell IDs Similar calculations happen for all the other services, all based on the service interval I created on the second tab. If you type "Clutch Oil" it auto fills in the latest date that service was performed in the "PDK Clutch Oil" date serviced in the top section, then auto calculates a Date Due based on the service interval on the second tab, in this case 6 years. Example: In the PDK section, you can type "Clutch Oil", "Trans Oil", or "N".Only use the options available in the drop down to ensure the upper section gets filled in and calculated correctly.
![car maintenance checklist spreadsheet car maintenance checklist spreadsheet](https://db-excel.com/wp-content/uploads/2018/11/home-maintenance-schedule-spreadsheet-spreadsheet-collections-in-home-maintenance-spreadsheet-686x970.jpg)
The "oil/filter" thru "AWD Diff" columns are drop-down data using data validation in order to calculate correctly.