I have a challenge, if anyone is kind enough to assist.
I can probably put a formula together for 1 condition, but the mix of mileage/date has be stumped!
I am attempting to create a spreadsheet for my boss that tells him if a vehicle is due a service. (I have been in this job 1 month and I would very much like to make myself useful!)
The thing is, its whatever condition arrives first, either a 1 or 2 yearly interval, or every 10/25k etc (this is for multiple vehicles and they are have different service intervals).
Is there a formula I can use that can address both of these conditions? I suppose the answer box would need to show an answer to be something like service due in "100 miles" or "1 month" depending on what condition was true? Maybe just "no" if neither condition true?
If the box could turn red/green that would be super helpful if its possible to add this in!
I can probably put a formula together for 1 condition, but the mix of mileage/date has be stumped!
I am attempting to create a spreadsheet for my boss that tells him if a vehicle is due a service. (I have been in this job 1 month and I would very much like to make myself useful!)
The thing is, its whatever condition arrives first, either a 1 or 2 yearly interval, or every 10/25k etc (this is for multiple vehicles and they are have different service intervals).
Is there a formula I can use that can address both of these conditions? I suppose the answer box would need to show an answer to be something like service due in "100 miles" or "1 month" depending on what condition was true? Maybe just "no" if neither condition true?
If the box could turn red/green that would be super helpful if its possible to add this in!