Results 1 to 12 of 12

Averaging out data from a DATEDIF Formula

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2007
    Posts
    32

    Averaging out data from a DATEDIF Formula

    Hi All,

    Im going insane trying to figure out how to Average out the data i've accumulated with the DATEDIF Formula...Can anyone please clarify if this is even possible ??

    Here's the situation...

    I've got a range of data that has been calculated by using the DATEDIF Function (below):

    =DATEDIF(H4,I4,"M")&" Months, " &DATEDIF(H4,I4,"md")&" Days"
    This is working fine, im getting the desired results (eg: '3 Years, 5 Months')...however, i now need to calculate the average of my DATEDIF Results and none of the formula's i try seem to work ??

    I've attached a small example of the Table that needs to be populated...Column E just needs to display the average of all the data in Column D...

    Thanks in Advance for any help you can provide.

    Cheers - Darren
    Attached Files Attached Files
    Last edited by DarrenH; 04-10-2008 at 03:10 AM. Reason: Error attaching Book1

Thread Information

Users Browsing this Thread

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

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