Find the average between two dates

[cperra]

I have an operation report that gets checked once per week. I need to average hours used between two dates and spread that average data in the well-hour used empty cells between those dates. For example:

Date	Day	Well 1 Hours Read	Well Hour Used
4/30/2023	Sunday
5/1/2023	Monday	22946.8
5/2/2023	Tuesday
5/3/2023	Wednesday
5/4/2023	Thursday
5/5/2023	Friday
5/6/2023	Saturday
5/7/2023	Sunday
5/8/2023	Monday	22953.8
5/9/2023	Tuesday
5/10/2023	Wednesday
5/11/2023	Thursday
5/12/2023	Friday
5/13/2023	Saturday
5/14/2023	Sunday
5/15/2023	Monday	22967.5

le:

 

[Bosquedeguate]

Just for clarification ... each time you have a reading listed you want to calculate the average between readings?
For example, you have a reading on 5/1 and on 5/8. therefore the Average calculation will be the difference between readings (22967.5 - 22953.8) divided by the number of days between readings?

Since there is not reading value, in your example , prior to 5/1 an average could not be calculated for 4/30 to 5/1.
Then a new average is calculated between 5/8 and 5/15.
Right?

 

[cperra]

Yes in my example we want to calculate the average between the readings and put the average result in all of the blank cells between those two readings. The results would go in the well hour used cells between those two dates. Above that 5/1 reading I will start a new running sheet that will have data above that date.