Need VBA Code to Update status of Action assigned for KRA Metrics

Dear experts

i need VBA code to fill average from column L:L of Team and Lead,

i have rawdata for calculating metrics points of KRA, i want get change status E & L Depends upon criteria

i want update in E & L E= Status & L=Score card Pts


J&K
if Start Date and End Date with in ETA Date Start and End Date Status = Completed and Scord is = 1
if Start Date and End Date with in After ETA Date Start and End Date But Status = Completed and Score is =.8
if Start Date and End Date Not with ETA End Date Status = InCompleted and Score = .5
and

calculating Points of Average for the month table in Metrics Sheet

find the attachment