I have created Userform to choose a start date and the end date will be after 365 days. I am using DateAdd function however I face a problem with leap year. For example, if I choose the starting date to be 28 Feb 2020, the end date will be 27 Feb 2020. But because of leap year if I choose 1 March 2020 as start date the end date will be 1 March 2021. May I know how to get the date to be 28 Feb 2021?
Bookmarks