ColdGeorge
Active Member
- Joined
- Aug 21, 2012
- Messages
- 407
- Office Version
- 2016
- Platform
- Windows
Dear all
This is my problem:
A1 shows date when a person was born for instance 05/10/1990, I want to show automatically on B1 next anniversary date in this case would be 05/10/2021. How can I complete this formula =DATE(YEAR(A1)+?,MONTH(A1),DAY(A1)) to achieve my goal?
Thanks in advance for your help, ColdGeorge
This is my problem:
A1 shows date when a person was born for instance 05/10/1990, I want to show automatically on B1 next anniversary date in this case would be 05/10/2021. How can I complete this formula =DATE(YEAR(A1)+?,MONTH(A1),DAY(A1)) to achieve my goal?
Thanks in advance for your help, ColdGeorge