Planned inspection sheet

[nomi_nomi]

Hi, I would like to make up an excel spreadsheet for our vehicle maintenance. some are inspected at 6 weeks and others are at 8 weeks. I would like excel to highlight the due dates 7 days before the inspection dates are due is this possible?
I copied blew formula from another post but It works until 9 weeks. when I put the number 10 or bigger it gives me the wrong answer.

Say you have the last inspection date in A2 and B2 says either "6 weeks" or "8 weeks" then in C2 this formula =A2+LEFT(B2)*7
Thanks

 

[etaf]

you are only taking the 1st digit, so 10 would actually just show 1 - hence the error
assuming the text in B2 always has a space and you only need upto 99 weeks
=A2+LEFT(B2,2)*7

Book6
	A	B	C
1
2	11/1/22	6 weeks	12/13/22
3	11/1/22	8 weeks	12/27/22
4	11/1/22	10 weeks	1/10/23
5	1/1/22	6 weeks	2/12/22
6	1/1/22	8 weeks	2/26/22
7	1/1/22	10 weeks	3/12/22
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=A2+LEFT(B2,2)*7

 

[nomi_nomi]

@etaf
It works. Thanks

 

[etaf]

you are welcome