Month Calculation
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
|