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