Rolling 12 months

[chef]

Hi
This may seem simple but unsure how to automate and hope I have explained ok.

I want to be able to have user type in any month in cell C3 and then excel populate the past 11 months in cells C4 to C14 eg type in Sept 2019 cell C3 and the rest will populate previous 11 months,same format, depending on month chosen, which will then give a rolling 12 month period.

any help would be appreciated.
regards

 

[FormR]

Hi, you could this in C4 copied down.

=TEXT(EDATE(C3,-1),"mmm yyyy")

 

[chef]

That works perfect and saves a whole lot of hassle.
Thanks so much for the help and quick reply
regards