auto forcast 6 months on, from a completed task (access or excel!.

creating a vehicle servicing database (300 vehicles) vehicles have annual MOT
and 6 monthly servicing intervals. Am trying to set up a
database/spreadsheet that will automatically forecast next date when current
inspection is marked as complete.

Also trying to get database/spreadsheet to alert user visually when MOT or
service is overdue

Currently have a Access database. Good but not helpfull due to amount of
user input required.
Many thanks Steve