Calculation using the number of months to show start and finish

Screenshot (12).png

Hi,

I think my brain has shut down early for Xmas.
What I'm trying to do is indicate the start month shown in Col A and then the subsequent number of months as indicated in col N. (see attached screen shot which has been completed manually)
Btw it doesn't need to show an * it could happily be the month itself.
I'm sort of getting there with lots of "IF", but can't quite get it right.
Any help would be much appreciated

Thanks

Dave

If your values in B1:M1 & A2:A3 are dates like01/01/2018 formated to show Jan, Feb etc then use this in B2 copied across & down
=IF(AND($A2<=B$1,EDATE($A2,$N2)>=B$1),"*","")

Originally Posted by Fluff13

If your values in B1:M1 & A2:A3 are dates like01/01/2018 formated to show Jan, Feb etc then use this in B2 copied across & down
=IF(AND($A2<=B$1,EDATE($A2,$N2)>=B$1),"*","")

Brill.
Thanks for that you've saved my brain from exploding.
I was almost there just having one of those days ;-)
Thanks again

Dave

You're welcome & thanks for the feedback