Ignoring Errors in Average Equation

Question

I would like to know if there is something to add to an equation to calculate the average of a range of cells but ignore the errors. 

These are the equations I used: 

=AVERAGEIFS(B:B, A:A, ">="&SUM(DATE(2020, 3, 20), TIME(0, 0, 0)), A:A, "<"&SUM(DATE(2020, 3, 20), TIME(1, , 0)))

=AVERAGE(OFFSET($I$2,(ROW()-ROW($L$2))*24,,24,))

I know that you can use the AVERAGE IFS function to ignore errors, however, I was wondering if there was a way to modify my equations?

Thank you!