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
|