How many left

B

Benj

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

Roger Govier

With date in A1 and number of months in B1
=DATE(Year(A1),Month(A1)+B1,Day(A1))
 
B

Bob Phillips

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)
 
O

olasa

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 (unde
Tools>Add-ins...
 
Top