If you have Date (what ever format) in A1, number of months in B1? then copy
past the exact line below in C1:
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))
Maybe you have to adjust by 1 day (1.1.2006...31.12.2006; not 1.1.2007)
then copy past
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)-1)
If you use European XLS format: separate the parameters in DATE with ; not ,

"Seldum" wrote:


Well the date cell is formattet as a date cell.

Heres how I solved the problem:

-Start date, a1: 01.01.06 - date field/cell
Periode, b1: 40 (month)-

QUESTION: HOW DO I CALCULATE THE END DATE?

Well I almost got the excact day +/-2
Answer, c1: = (365/12)*b1+a1

I almost got the excact date using this rather simple formula. Its not
100% precise but in this case its good enough.


--
Seldum
------------------------------------------------------------------------
Seldum's Profile: http://www.excelforum.com/member.php...o&userid=35793
View this thread: http://www.excelforum.com/showthread...hreadid=555594