=IF(DATE(YEAR(A2),MONTH(B2),DAY(B2))<A2,DATE(YEAR(A2)+6,MONTH(B2),DAY(B2)),DATE(YEAR(A2)+5,MONTH(B2),DAY(B2)))
Date Calculation
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
If an Application Approved Date is in A2 and a person's Birthdate is in B2, How can I have C3 auto calculate 5 years from the application date on the subsequent birthday?
| Application Date | Birthdate | Expiration Date |
|---|---|---|
| 12/15/2024 | 10/9/1969 | |
Microsoft 365 and Office | Excel | For business | Android
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
Accepted answer
-
Anonymous
2025-01-07T15:56:21+00:00