unanswered Extract Years from Start and End Dates with Custom Text Year1, Year2 and so on

More
4 months 6 hours ago #2186 by Aleem
Hi,
This is my first post in this forum, I'm wondering if we can get the Years in Range from Start Date and End Date and the custom text in the adjacent columns thru VBA.
Example
Start Date 01-Jul-2015
End Date  30-Jun-2020

Expected results
Years
Year1  2015
Year2 2016
Year3  2017
Year4  2018
Year5  2018
Year6  2020
Thank you for your time and suggestion

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun