Need average of days for date values from date to current day that updates current date

**FinGhost** · 08-12-2013, 01:21 PM

I have cells A4:A44 (00/00/00) that have dates in them and I wanted to turn cell K2 to have the current date automatically populate. My problem is in A4:A44 are the dates that an application started and I wanted cell M2 to display the average amount of days from the dates in cells A4:A44 to the current date, so I can get how long we have had these applications on average

**FinGhost** · 08-12-2013, 01:53 PM

Somebody has to know the answer, I think I am over thinking it

**FinGhost** · 08-12-2013, 04:14 PM

Come on forum team

**daddylonglegs** · 08-12-2013, 04:38 PM

The simplest way is simply to average the dates in your range and subtract that from today's date so if K2 has the formula

=TODAY()

then for the average age of your applications use

=K2-AVERAGE(A4:A44)

format result cell as number or general

**FinGhost** · 08-12-2013, 04:41 PM

thank you, that was more simple than I was thinking it needed to be

Need average of days for date values from date to current day that updates current date

LinkBack

Thread Tools

Rate This Thread

Display

Need average of days for date values from date to current day that updates current date

Re: Need average of days for date values from date to current day that updates current dat

Re: Need average of days for date values from date to current day that updates current dat

Re: Need average of days for date values from date to current day that updates current dat

Re: Need average of days for date values from date to current day that updates current dat

Thread Information

Users Browsing this Thread

Similar Threads

calculate number of days between two date within a current month including end date

[SOLVED] Excel 2007 : Subtract date from a current date and show difference in months and days

adding current date then after saving the file current date function stops

I want any date 90 days or older from current date change color

[SOLVED] Calculating days between current date and a date in future NETWORKDAYS() fun

Bookmarks

Bookmarks

Posting Permissions