One way ..

Assuming date is in A1

Try

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

(plus 1 year)

In C1: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

(plus 6 months)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Mukund" wrote in message
...
how to calculate date 6 months after a particular date or 1 year after the
said date