So each row is represents just 1 day?

Isnt this simply

=AVERAGE(B1:AE1)

copied down a spare column?