Averaging project lifespans - months, days

**CHromedavid** · 09-20-2020, 09:51 PM

I have numerous projects listing their start/completion life span, in months and days, for example: 1 months, 15 days; 0 months, 28 days etc (Formula reference: =DATEDIF(startdate,enddate,"m")&" months, "

I now want to calculate the Average of all lifespans but I’m unable to compose the correct formula.

Help greatly appreciated.

**bebo021999** · 09-20-2020, 10:09 PM

Try DATEDIF with start date and end date is range, not single cell like this:

=AVERAGE(INDEX(DATEDIF(C2:C4,D2:D4,"m"),))

Averaging project lifespans - months, days

LinkBack

Thread Tools

Rate This Thread

Display

Averaging project lifespans - months, days

Re: Averaging project lifespans - months, days

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Calculating Years, Months, Week, Days, Hours, Minutes for Work Days between two dates

How do I convert years, months, days back to complete days

Adding together and averaging a column of data in the format years, months and days

spreading a project value over a number of months based on order month & project duration

[SOLVED] Match date to project in array and calculate days since last project of same name

Convert days -> Years, Months, Days, Hours, Minutes, Seconds

Averaging Last 6 Months

Bookmarks

Bookmarks

Posting Permissions