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!!

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!!

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!!

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