Similar problem with an added step. I need to return how many months have passed to the end of the year, since a start date. So let's say my A1 is 02/01/2017 and the answer is 11 months. Then for A2, the date is a year later, 02/01/2018 and I need to return 23 months and so on with an offset end date of 4/30/2028 returning 123 months. Any ideas? I need to automate this so if I change a constant 123 months, it will return the proper values every year.