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),""))
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),""))
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");"")
@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
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks