Change Month and Year in cell depending on todays date

[Jaffabfc]

Hi,

In Cell F5 i am wanting the cell today say Jan 2017 Hitrate if we are in January. If we go to February i want it to change to Feb 2017 Hitrate, and so on for every month after.

What possible formula can i do?

Ive tried putting it next to todays date on another tab and then vlooking against today() formula but it doesnt seem to work.

Tried =text(today(),"mmm-YYYY"&" Hitrate")
but that doesnt want to work either.

Any other ideas?

thanks

 

[FormR]

Tried =text(today(),"mmm-YYYY"&" Hitrate")

Hi, try this small amendment.

=TEXT(TODAY(),"mmm YYYY")&" Hitrate"

 

[FormR]

In Cell F5 i am wanting the cell today say Jan 2017 Hitrate if we are in January. If we go to February i want it to change to Feb 2017 Hitrate, and so on for every month after.

Or if you really did mean 2017 then..

=TEXT(EOMONTH(TODAY(),-12),"mmm YYYY")&" Hitrate"

 

[Tetra201]

Or this small amendment:

=TEXT(TODAY(),"mmm YYYY ""Hitrate""")

 

[Jaffabfc]

spot on everyone thanks.

Yes i should have realised i wouldnt get 2017 if i just put today() without -12. typical mistake lol.

Thanks again i knew i was close