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

1. ## 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. ## 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. ## 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.

##### Users Browsing this Thread

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

#### 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