# 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),""))  Register To Reply

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");"")  Register To Reply

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.  Register To Reply