Originally Posted by Claus Busch

Hi,

Am Mon, 12 Nov 2012 19:17:18 +0000 schrieb Moideen:

Coloumn 1 (Invoice Date) : 05-07-2012

Coloumn 2 (Limit the Period) : 5

Coloumn 3 Need Result : 05-12-2012

try:
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2