I have a work tracking file. in which works are planned according to week. in sheet dme, LD 10 to LU 10 are week dates. (21 oct to 26 oct).
please look LI 4 & LI 5. and K 4 & k5

LI 4 shows the work done on time for k4 and LI5 shows the work late for k5

for cell LI 4 (on time) the condition is that if LG 12:LG 49 is greater than or is equal to LH 12: LH 49. than it should be shown up how many works are done on time.

for cell LI 5 (late) the condition is that if LG 12:LG 49 is less than LH 12: LH 49 then it should shown up how many works are done late. please check and rectify the formula or if need any other formula then i will also like to have that which can fulfill both conditions mentioned above.

here is the link of file.
https://docs.google.com/spreadsheets...#gid=862940781