Overdue day count based off of frequency

[hk98]

I run a maintenance business and I've decided to make an excel sheet that tracks if my technicians are keeping up with their service on a weekly, biweekly, or monthly basis.
I figured the easiest way might be by changing "biweekly" to 14 and "monthly" to 30 like I set up the true/false statements to make the formula easier but that is as far as I have gotten since I am highly unfamiliar with date functions...

Either way, my goal is to have another column that states how many days (or weeks/months) a service is overdue in reference to the most recent service conducted and how frequently they should be visited.

Hopefully that was coherent enough for someone to understand. Any and all help/recommendations are greatly welcomed and appreciated.

 

[gelu]

Hi HK,

Hope this helps>

Book1
	A	B	C	D	E
1
2		Service		On time?
3		Due	Accomplished	every 10 days	Overdue?
4		21-Oct-22	31-Oct-22	0	FALSE
5		20-Oct-22	31-Oct-22	-1	TRUE
6		19-Oct-22	31-Oct-22	-2	TRUE
7		18-Oct-22	1-Nov-22	-4	TRUE
8		17-Oct-22	1-Nov-22	-5	TRUE
9		21-Oct-22	7-Nov-22	-7	TRUE
10		20-Oct-22	30-Oct-22	0	FALSE
11		19-Oct-22	30-Oct-22	-1	TRUE
12		18-Oct-22	30-Oct-22	-2	TRUE
13		17-Oct-22	31-Oct-22	-4	TRUE
14		21-Oct-22	5-Nov-22	-5	TRUE
15		20-Oct-22	6-Nov-22	-7	TRUE
16		19-Oct-22	29-Oct-22	0	FALSE
17		18-Oct-22	29-Oct-22	-1	TRUE
18		17-Oct-22	29-Oct-22	-2	TRUE
19		21-Oct-22	4-Nov-22	-4	TRUE
20		20-Oct-22	4-Nov-22	-5	TRUE
21		19-Oct-22	5-Nov-22	-7	TRUE
22		18-Oct-22	28-Oct-22	0	FALSE
23		17-Oct-22	28-Oct-22	-1	TRUE
Sheet1

Cell Formulas
Range	Formula
D4:D23	D4	=$D$3-DAYS(C4,B4)
E4:E23	E4	=D4<0

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E4:E23	Cell Value	=TRUE	text	NO
E4:E23	Cell Value	=FALSE	text	NO