Ravi Sir's Cards › Excel
Car Service Garage Management System in Excel (card 1 of 2)
Revision card 1 for Car Service Garage Management System in Excel: Next service due date: =EDATE(E5,Setup!$B$8) gives 16-04-2027; Days left: =F5-Setup!$B$3 gives 181; Reminder flag: =IF(G5<0,"Overdue",IF(G5<=Setup!$B$9,"Call now","OK")) gives OK. Includes an example data table.
Read card text
What this card says
1 for Car Service Garage Management System in Excel: Next service due date: =EDATE(E5,Setup!$B$8) gives 16-04-2027
Days left: =F5-Setup!$B$3 gives 181
Reminder flag: =IF(G5<0,"Overdue",IF(G5<=Setup!$B$9,"Call now","OK")) gives OK. Includes an
Example
data table
Learn this in the lesson: Car Service Garage Management System in Excel: Job Cards, Parts and Labour, GST Invoice, Service Reminders and Dashboard