Try This..
Formula:
=IF(A2<DATEVALUE("1/1/1955"),DATE(YEAR(A2)+65,MONTH(A2),DAY(A2)),DATE(YEAR(A2)+67,MONTH(A2),DAY(A2)))
Try This..
Formula:
=IF(A2<DATEVALUE("1/1/1955"),DATE(YEAR(A2)+65,MONTH(A2),DAY(A2)),DATE(YEAR(A2)+67,MONTH(A2),DAY(A2)))
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks