Remember Me?

#1
December 1st 04, 11:41 PM
 Mel Posts: n/a
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

#2
December 1st 04, 11:51 PM
 Dave R. Posts: n/a

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

#3
December 1st 04, 11:52 PM
 JE McGimpsey Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mike R Excel Discussion (Misc queries) 7 January 20th 05 10:07 PM Judy Excel Discussion (Misc queries) 2 December 15th 04 03:38 PM LZC Excel Worksheet Functions 3 November 27th 04 08:10 PM o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM WickyWick Excel Worksheet Functions 2 November 9th 04 09:01 PM

All times are GMT +1. The time now is 11:00 PM.