In simple terms add 6 to the month or 1 to the year

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

but be aware, this will make 30-aug the 02-Mar

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mukund" wrote in message
...
how to calculate date 6 months after a particular date or 1 year after the
said date