Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How many left
Hi all and thx for the past!
how do i calculate from a specific date given in one cell + number (say 10 [representing months]) given in another cell, so the value should be the date ahead in say 10 months? and it should show me the date in the value. Thanx to u all in advance!! |
#2
|
|||
|
|||
With date in A1 and number of months in B1
=DATE(Year(A1),Month(A1)+B1,Day(A1)) -- Regards Roger Govier "Benj" wrote in message ... Hi all and thx for the past! how do i calculate from a specific date given in one cell + number (say 10 [representing months]) given in another cell, so the value should be the date ahead in say 10 months? and it should show me the date in the value. Thanx to u all in advance!! |
#3
|
|||
|
|||
Assuming the 10 is in cell A1, you can sum a range using
=SUM(INDIRECT("A2:A"&A1)) Is this what you mean? -- HTH RP (remove nothere from the email address if mailing direct) "Benj" wrote in message ... Hi all and thx for the past! how do i calculate from a specific date given in one cell + number (say 10 [representing months]) given in another cell, so the value should be the date ahead in say 10 months? and it should show me the date in the value. Thanx to u all in advance!! |
#4
|
|||
|
|||
Try this: =EDATE(date,10) 28/7/2005 -- 28/5/2006 HTH Ola Sandström Note: The Analysis ToolPak add-in must be switched on (under ToolsAdd-ins...) -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390862 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing: repeating columns on left and RIGHT | Excel Discussion (Misc queries) | |||
Making MIcrosoft Word type from Right to Left | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
header in right or left margin? | Excel Discussion (Misc queries) |