On Sat, 10 Dec 2005 04:59:02 -0800, viktor
wrote:

hi,

how can i calculate the end date(mm/yyyy) betwen one cell where i have a
date(dd/mm/yyyy) and in another cell i have a number of month(12)

ex: A1: 01/01/2005 B1: 12 in C1 i should obtain 12/2005

Thanks

Hmmm, if add 1 month to 1 Jan 2005 I get to Feb 2005. If I add 12 months, I
get to Jan 2006.

If you have the Analysis toolpak installed, the easiest method is the function:

=EDATE(A1,12)

But depending on the result you want, you may need to subtract 1 from the 12.


--ron