Sep 15 2021 07:58 AM - edited Sep 15 2021 07:59 AM
Sep 15 2021 07:58 AM - edited Sep 15 2021 07:59 AM
Hi - I have a complex (to me!) excel formula needed that I cannot get my head around.
I have a spreadsheet with two tabs. One as a 'Dashboard' and the second tab as the data to run this. The dashboard shows 4 columns and multiple rows.
Essentially I am tracking each registration (vehicle) that has a service every 14 days. The service alternates between service 1 and service 2.
Column A - Registration
Column B - Last Service
Column C - Next Service
Column D -
Column A-C is fine and working however I cannot come up with a formula to put in column D that shows what the next service will be.
The data sheet is used to record registration, service date and type of service.
Any help really appreciated.
Thanks,
Sep 15 2021 08:16 AM
Sep 15 2021 08:37 AM