Results 1 to 4 of 4

Finding current lifetime age

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Erie, PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Finding current lifetime age

    I need to find the expected lifetime of a person at a current age based on gender. If the person is male and 72 I need the expected lifetime which is 84.4, if the person is female and 85 then I need the cell to be populated with the correct expected lifetime number of 91.8.
    How do I do this? Also I have the ages updated each day the worksheet is opened based on their date of birth using this forumla in the orginal worksheet =ROUND(DATEDIF(L3,M3,"m")/12,0)

    PLease help!
    Attached Files Attached Files

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