Year number in a column for data in another column.

[Patthar]

I have month numbers in Column A numbered 1,2,3,4,5 and so on for 30 years with the last number 360.

In column B I want corresponding years - for eg. Against numbers 1 to 12 in column A, I want the text "Year 1" in column B and against numbers 13 to 24 in Column A, I want the text "Year 2" in column B and so on....

Is there a formula available to do this?

Thank you

[samba_ravi]

try below formula
=IF(A1="","","Year "&INT((A1+11)/12))
or
=IF(A1="","","Year "&ROUNDUP(A1/12,0))

[Patthar]

It works, Thanks for the prompt response Samba_Ravi.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.