One way:

U2: =DATE(2004,11+T2,1)


Format as mm/yy (or preferred format), which would return 11/04 for
T2=0, 12/04 for T2=1, etc.



In article ,
Mel wrote:

I am having trouble with a formula that would give the month and date from a
certain month.
In cell S2 (Ending stock as of Oct 31)
T2 (# of months before runout)
U2 (month/year of runout)

Could someone help with the formula for U2.

Thanks