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

4 months 6 hours ago #2186 by Aleem
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.
Start Date 01-Jul-2015
End Date  30-Jun-2020

Expected results
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