Month & Year

  • Thread starter Thread starter RayD
  • Start date Start date
R

RayD

Hello everyone,

Well I though this was going to be easy (probable still is). The month
will be the same but I want the "year" to change when I change it in
cell B100 (or what ever cell). Not having to much luck. Can anyone
shed some light on this?


="January"&(B100)

Thanks
 
Looks nothing but perfect from here. What's in B100, a year number ? If not, if it's a
date, then perhaps
="January "&YEAR(B100)
 
Hi Ray,

That works for me. You don't need the () but it works with
or without. If you want a space between the two:

="January "&B100

Or, if the year is not updating maybe you have calculation
set to manual. Tools>Options>Calculation

Biff
 
Back
Top