Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mel
 
Posts: n/a
Default 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   Report Post  
Dave R.
 
Posts: n/a
Default

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formula Mike R Excel Discussion (Misc queries) 7 January 20th 05 11:07 PM
How do I convert a serial number to the month, day, and year in E. Judy Excel Discussion (Misc queries) 2 December 15th 04 04:38 PM
Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 09:10 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 10:01 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"