CODEWITHSUNDEEP
exceldaterangeformula
NHure92
NHure92

Reputation: 105

Average of two date columns

I've got two columns in my workbook with an open and close date, and I am looking to get an average date range (holding period) from the two columns. For example, if the open date in cell A1 is 19/11/2014 and the close date in cell B2 is 21/11/2014, the average holding period would be two days. I've attached a screenshot of the aforementioned columns to provide context. Any help on this would be great!

Upvotes: 0

Views: 534

Answers (1)

Lambik
Lambik

Reputation: 520

What you are looking for, based on your explanation is NOT an average, but rather the holding duration, being the difference between close and open date. If you want, you can calculate (in a second step), the average of those differences.

I suggest you add to column C

=DAYS(B1,A1)

and you format that as Number. Subsequently, you can calculate the average of the values in column C to get the average holding period for all your entries using:

=average(C:C)

Upvotes: 1

Related Questions