Formula to convert to month
 

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

Not sure if I understand the question, but if you're looking to add x number
of months to a date, you can use

=EDATE(A1,6)

if A1 contained 1/1/2004
then the formula returns 7/1/2004.


"Mel" wrote in message
...
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

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