Excel Spreadsheet for vehicle maintenance

[Phildux]

hello i would like to make up an excel spreadshheet for our vehicle maintenance. some are are inspected at 6 weeks and others are 8 weeks. i would like ecxel to high light the due dates 7 days before the inspection dates are due is this possible? also to cindiser are test dates ect any help would be greatly appreciated

 

[nomi_nomi]

Hi Barry Houdini, I tried your formula it works if the weeks are maximum 9. When I put weeks 10 or greater than 10 it shows the wrong result.

 

[RoryA]

@nomi_nomi
This thread is 17 years old and Barry sadly doesn't post here any more. I suggest you start your own thread, please.