Calculate the 6th month from start date

**isaching** · 12-25-2013, 10:17 PM

Please can someone help, I need a formula to calculate a date 6 months
forward from the start date. However, in the calculated 6th month, I need it to the day before the start date.
ie: start date: 26/12/13 -- End date: 25/06/14

Any help would be much appreciated.

Thanks in advance

**Tony Valko** · 12-25-2013, 10:20 PM

Try this...

A2 = start date

=EDATE(A2,6)-1

Note that the EDATE function requires the Analysis ToolPak
add-in be installed if you're using a version of Excel prior to
Excel 2007. If you enter the formula and get a #NAME?
error look in Excel help for the EDATE function. It'll tell you
how to fix the problem.

**Evan_lin** · 12-25-2013, 10:53 PM

You can try.
=DATEDIF(A2,B2,"M")+DATEDIF(A2,B2,"MD")/30

**Evan_lin** · 12-25-2013, 10:54 PM

If A1=start date,B1=End date
you can try this.
=DATEDIF(A1,B1,"M")+DATEDIF(A1,B1,"MD")/30

Calculate the 6th month from start date

LinkBack

Thread Tools

Rate This Thread

Display

Calculate the 6th month from start date

Re: Calculate the 6th month from start date

Re: Calculate the 6th month from start date

Re: Calculate the 6th month from start date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Calculate Pricing from Start and End Date with different Pricing Weight for Each month

[SOLVED] Calculating contribution of sales by month with given amount, start date, and end date

Rows of records, each w/ start & end date. Need to compile and summarize month by month

Need help of getting current month date from start to end!!

Take user input start date and end date. Create a column for each month between these

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions