Adjust EOMONTH formula to return closest end of month date to today?

So in one cell I have the TODAY() function and in another cell I am referencing that cell to obtain the end of month date using the EOMONTH formula. Is there anyway to adjust this formula so it would produce the below results:

Today is 1/19/17 - Formula Returns 1/31/17
Today is 2/4/17 - Formula Returns 1/31/17

So what I am looking for is a formula that would return the closest end of month date to the current date, even if that end of month date is the month prior as in the second example.

Thanks for the help.

Originally Posted by AlKey

Enter in B1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B
1	1/19/2017	1/31/2017
2	2/4/2017	1/31/2017

Thanks for the reply.

When I enter that formula in B1 and then change A1 to say 2/5/17, B1 returns 2/28/17?

=date(year(a1),month(a1)+if(day(a1)>15,1,),)

Originally Posted by AliGW

Try this formatted as a date:

=IF((A1-EOMONTH(A1,-1))<(EOMONTH(A1,0)-A1),EOMONTH(A1,-1),EOMONTH(A1,0))

For whatever reason the first two answers did not work when copying and pasting the formulas provided, but this one did.

Thank you all for the help!