Get Average of Days from Date Range

[codesRus]

I wanted to make sure I have the correct formula before using it for a report. Could someone validate that this would be the formula to get a date range startdate (col C) to enddate (col D) and the days are indicated in col G. This is a wide range and not limited to one row.

=AVERAGE(IF('Sheet1'!$C:$C>=A8,IF(Sheet'!$C:$C<=C8,'Sheet1'!$D:$D)))

Where A8 is the startdate for the week, and C8 is the enddate for the week on a different work sheet. G specifies the days. The above formula is only for col C though, and I want to add col D with the date range too.

[dilipandey]

Hi codeRus,


I do not see the use of col G in your formula.. would suggest you to upload the sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[codesRus]

Sorry about that, I meant to have col G as follows where the days will be indicated.

=AVERAGE(IF('Sheet1'!$C:$C>=A8,IF(Sheet1'!$C:$C<=C8,'Sheet1'!$G:$G)))

I want the formula to get the date range specified in A8 and C8 on Sheet3, and to pull date range data and days from Sheet1. Some dates are still not filled in as of yet, but just looking for the average of days for the ones filled in.

[dilipandey]

HI CodesRus,


See the attached file... sheet 3, yellow cell:-
sample_book.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[codesRus]

Thank you very much!!! this really helps.

[dilipandey]

You are welcome codesRus....

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>