Hi,

Another way

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
and obviously +6 for 6 months

Mike

"Shahin Khan" wrote:

If today is 08 NOV 2008 after Three or six months later what date going to
be. How can I create a function in MS Excel. Can you please let me know.

My e-mai is
or


Thanks,

Shahin Khan