As I have commented above to explain this more clearly, I am posting it here with some screenshots.

1. If the cells are not formatted as text then, use INT()

• Formula used in cell B1

=INT(A1)

2. Or, If the cells are not formatted as text or if formatted as text then, use TEXTBEFORE() or TEXTSPLIT()

• Formula used in cell B1

=TEXTBEFORE(A1,".")/1

Or, in cell B2

=@TEXTSPLIT(A1,".")+0

3. Or, If the cells are not formatted as text or if formatted as text then then, use LEFT() with FIND()

• Formula used in cell B1

=LEFT(A1,FIND(".",A1)-1)*1

Now, here comes the question, why you shouldn't be using the RIGHT() to extract the date,

As in Excel’s Date and Time values are stored as floating-point numbers, with the whole number representing the number of days since 1st January 1900 and the fractional part representing the time of day as a fraction of 24 hours. This allows Excel to perform various calculations with ease, making it highly useful for business and scientific purposes.

Here is what you are getting using RIGHT() which should be avoided as INT() function dedicatedly extracts the date, bt there are other functions like I have shown which can be used. From the screenshot below you can see when you select the cell A2 and hit CTRL+SHIFT+~ or click CTRL+1 to open format cells and select as Category Number it turns into a floating point numbre, so it is clear they are not stored as text, if its in TEXT format, then you can use one of the formulas as shown above.

Also note: When using those TEXT functions like LEFT or TEXTSPLIT() or TEXTBEFORE() i have either added with 0 or multiplied with 1 or divided by 1 so as to convert them to a number as the return is a text, also you can add double unary -- before the formula, which does the same. Hope it explains well !

Edit : In addition to the Clause if formatted as text then:

• In cell B1

=TEXTBEFORE(A1," ")+0

Or, in cell B2

=@TEXTSPLIT(A2," ")/1

Or, in cell B3

=LEFT(A3,FIND(" ",A3)-1)*1

Notes: Solutions posted above assumes the cells or the range of cells do not have any non-printable characters, in that scenarios the formulas may differ slightly to parse those characters. Usually the non-printable offending characters codes are 160, 127 etc which can be removed using SUBSTITUTE() function. That said, then

=INT(SUBSTITUTE(A1,CHAR(160),)/1)

Or,

=TEXTBEFORE(SUBSTITUTE(A1,CHAR(160),),".")+0