+ Reply to Thread
Results 1 to 3 of 3

Calculation of current age when date of registration and age at registration are given

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Calculation of current age when date of registration and age at registration are given

    How to calculate the current age if Date of registration and age at the registration given trying below but not getting, what should be at .........

    =(IF(AND(D7<>"",H7<>""),MAX(((.............-H7)/365)+D7,D7),""))

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,783

    Re: calculation of current age when date of reg and age at reg are given

    first approximation would be (if your age when registered is in D7 and reg date in H7:
    =(IF(AND(D7<>"",H7<>"");D7+DATEDIF(H7,TODAY(),"Y");"")

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,419

    Re: calculation of current age when date of reg and age at reg are given

    @lalit

    Our vigilitant member macropod is pointing out that you're in a Word forum when this is an Excel question. I see you've received an answer but I'll nevertheless move it over to the Excel Formulas and Functions area for the benefit of others who might be searching for something similar.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. New registration.
    By BradysofOC in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-28-2013, 07:31 AM
  2. First log-on and registration
    By Gizmcito in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-15-2013, 09:24 PM
  3. Draft day registration help!
    By quicksilver119 in forum Excel General
    Replies: 4
    Last Post: 03-15-2011, 07:57 AM
  4. Summing total registration up to a date
    By ct711 in forum Excel General
    Replies: 2
    Last Post: 12-04-2010, 01:50 AM
  5. [SOLVED] xlm udf registration
    By ntoze in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09:20 AM

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