View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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