how to calculate date 6 months after a particular date or 1 year after the
said date

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

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

On Tue, 11 Jan 2005 01:33:04 -0800, Mukund
wrote:

how to calculate date 6 months after a particular date or 1 year after the
said date

In the general solutions others have posted, consider what date you wish to
show when adding 6 months to Aug 31. The formula given will -- 3/3 or 3/2.
If this is not satisfactory, have a look at the EDATE worksheet function
(requires the analysis tool pak to be installed as per its HELP).


--ron