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

=DATE(YEAR(A1),MONTH(A1)+12,DAY(A1))-1

Format Custom as "mm/yyyy"

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

Try the following:
=date(year(A1),month(A1)+B1,day(A1))

Given your example, you may need this:
=date(year(A1),month(A1)+B1-1,day(A1))
"viktor" wrote in message
...
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

Hi Viktor

If you have the Analysis Toolpak loaded, (ToolsAddinsAnalysis Toolpak) then
=EOMONTH(A1,B1-1)

Regards

Roger Govier


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

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