convert rolling number to month/year

[knewt99]

Please help if you know a way to do this.

In a newspaper publication file I have a number field for the issue number - 125, 126, 127 etc.

I need a calculation to convert these numbers into the issue month and year.

Issue 125 = Feb 06,

Issue 126 = Mar 06

Issue 127 = Apr 06 etc.

As new issues are added the calculation will need to continue on into future years. The further catch is that there are only 11 issues per year. They don't publish in July.

Thanks for any ideas.

[comment]

Try:

Let ( [

y = Div ( Issue - 3 ; 11 ) + 1995 ;

m = Mod ( Issue - 3 ; 11 ) + 1

] ;

Date ( m + (m > 6) ; 1 ; y )

)

The result is date. Format the field to display as mmm yy.

[knewt99]

Works perfectly!

Thanks for the help.