end of the month formula with only year and month

[jeongs1]

Hello, my cell have "201801 Sale" in A1.
What is the formula that I can use in B1 so that I get the end of the month date? (i.e. 1/31/2018)

Thank you

 

[orsm6]

=EOMONTH(A1,0)

apply a custom format to cell B1 if needed, "mm/dd/yyyy"

 

[jtakw]

Hi,

Cell B1 formatted as Date:

Excel 2010
	A	B
1	201801 Sale	1/31/2018
Sheet1

Cell Formulas
Range	Formula
B1	=EOMONTH(DATE(LEFT(A1,4),MID(A1,5,2),1),0)

 

[Marcílio_Lobão]

jeongs1, Good evening.

Try to use:

B1 --> FORMULA -->

=EOMONTH(DATE(--LEFT(A1,4),--MID(A1,5,2),1),0)

Formata cell B1 as custom --> mm/dd/aaaa

Is that what you want?

I hope it helps.

 

[wideboydixon]

=EOMONTH(DATE(LEFT(A1,4)+0,MID(A1,5,2)+0,1),0)

Perhaps?

WBD