If Statement to Pull a month from a date of a names range that contains 3 columns

[julie227]

I use a main database with many pivot tables to track sales cancellation, renewals and non-renewals
.

I have 3 columns for the date tracked depending on if it is a cancel, non-renewal or a renewal. I then have column to show the month tracked which is use in a pivot table. I named a range for the three date columns. How can I put that named range into an IF statement produce the month? Thank you.

 

[goesr]

Hi Julie227 - Welcome to the board! I think an example of your data would help everyone understand what you are looking for.

Happy Excelling,

goesr

 

[julie227]

Hi Julie227 - Welcome to the board! I think an example of your data would help everyone understand what you are looking for.

Happy Excelling,

goesr

What I am trying to accomplish is the following

Cancel Tracked Renewal Tracked Non-Renewal Tracked Month Tracked

The above are my columns and I would like if there is a date in any of the first three, then populate the correct month written out such as 1/6/2014 -January. Thank you.

 

[goesr]

Hi julie227 - If I understand you correctly, in column D, try the formula:

=IF(A1<>"",A1,IF(B1<>"",B1,IF(C1<>"",C1,"")))

Then change the format in column D to a custom format of mmmm (which will just show the month).

Hope this helps,

Happy Excelling,

goesr

 

[goesr]

Hi julie227 - Below is what my data looked like for testing:

Cancel</SPAN>	non-renewal</SPAN>	renewal</SPAN>	MONTH</SPAN>
	4/4/2004</SPAN>		April</SPAN>
5/6/2007</SPAN>			May</SPAN>
	2/2/2002</SPAN>		February</SPAN>
		9/9/2009</SPAN>	September</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=4></COLGROUP>

 

[julie227]

Hi julie227 - Below is what my data looked like for testing:

Cancel	non-renewal	renewal	MONTH
	4/4/2004		April
5/6/2007			May
	2/2/2002		February
		9/9/2009	September

<tbody>
</tbody>

I am almost there but I cannot get the custom format work. I get a J for January. Other than that, it works perfect. Thank you so much. I do need to get the full month in there.

 

[goesr]

Hi julie227 - You ARE very close! Custom formats are such that:

1. m results in just 1
2. mm results in 01
3. mmm results in Jan.
4. mmmm results in January

Cancel</SPAN>	non-renewal</SPAN>	renewal</SPAN>	MONTH</SPAN>	Custom Format</SPAN>
1/1/2011</SPAN>			1</SPAN>	m</SPAN>
	1/4/2011</SPAN>		01</SPAN>	mm</SPAN>
		1/15/2011</SPAN>	Jan</SPAN>	mmm</SPAN>
		1/8/2011</SPAN>	January</SPAN>	mmmm</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=4><COL></COLGROUP>

Play around with it a little and I'm sure you will get it.

Happy Excelling,

goesr

 

[julie227]

I am sooooo happy. I got it to work. A huge THANK YOU

Hi julie227 - You ARE very close! Custom formats are such that:

1. m results in just 1
2. mm results in 01
3. mmm results in Jan.
4. mmmm results in January

Cancel	non-renewal	renewal	MONTH	Custom Format
1/1/2011			1	m
	1/4/2011		01	mm
		1/15/2011	Jan	mmm
		1/8/2011	January	mmmm

<tbody>
</tbody>

Play around with it a little and I'm sure you will get it.

Happy Excelling,

goesr