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