Date range

[tmwin]

I have a date range that always covers a span of 3 different months. The net number of days and dates will vary. What formulas can I use to determine the month and year of the middle month?

Example:

Date range = 3/10/14-5/20/14
Required output = 042014

Thanks for the help!

 

[bbott]

Is your date range all in one cell?

 

[tmwin]

The date range is two cells. The start date is in one and end date is in another.

 

[FormR]

I have a date range that always covers a span of 3 different months. The net number of days and dates will vary. What formulas can I use to determine the month and year of the middle month?

Example:

Date range = 3/10/14-5/20/14
Required output = 042014

Thanks for the help!

Does this work for you?

Excel Workbook
	A	B	C
1	10-Mar-2014	20-May-2014	042014
Sheet1

 

[tmwin]

Perfect. Thank you very much!

 

[tmwin]

I am having trouble running a vlookup off of the output to a MONTH()&YEAR() formula. Is there a way to adjust this formula or use a different one to lookup off the MMYYYY text output?

 

[FormR]

Hi,

You could try changing your MONTH()&YEAR() formula to:
=TEXT(A1,"MMYYYY")

Or you could try changing the formula suggested in this thread to:
=TEXT(EOMONTH(A1,1),"MYYYY")

If neither of these work - it would probably help if you could post the MONTH()&YEAR() formula here.

 

[tmwin]

Hello,

I am continuing to run into problems when I vlookup off of the text formula.

Below is a copy of the MONTH()&YEAR() formula.

=month(b2)&year(b2)

b2=1/1/2012

Thanks again for the help!

 

[FormR]

I am continuing to run into problems when I vlookup off of the text formula.

Hi, can you post the VLOOKUP() formula and a small screen shot of the lookup value and data you are looking for a match in, also you could expand on the problems you are experiencing (i.e. is the VLOOKUP() formula returning an error or a wrong result)?

You can use one of the following tools to post your example data directly into a reply:
Download
how to create table like Aladin