Date Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate fractions using dates 6
Excel Average dates help 0
Calculate month & year in between two dates 2
Excel PRICE function: How does it compute Issue Date of the Security 5
Calculate eligibility/enrollment date 8
IF and DATE Formula Help PLEASE 6
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
I need help with a Function 0

Back
Top