Date Calculation

M

Mukund

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

Max

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)
 
B

Bob Phillips

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)
 
R

Ron Rosenfeld

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

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
 
Top