+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2010
    Posts
    24

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

    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

  2. #2
    Registered User
    Join Date
    07-01-2013
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2010
    Posts
    24

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

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

  3. #3
    Registered User
    Join Date
    07-01-2013
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2010
    Posts
    24

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

    Come on forum team

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

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

    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
    Audere est facere

  5. #5
    Registered User
    Join Date
    07-01-2013
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2010
    Posts
    24

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 14
    Last Post: 04-06-2015, 09:19 PM
  2. Replies: 15
    Last Post: 06-26-2012, 07:28 AM
  3. adding current date then after saving the file current date function stops
    By gotbitey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 02:15 PM
  4. I want any date 90 days or older from current date change color
    By Big Abalone in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2006, 12:10 AM
  5. [SOLVED] [SOLVED] Calculating days between current date and a date in future NETWORKDAYS() fun
    By Faheem Khan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1