I'm running INT on 'February 12, 2022 09:45 AM' and it's returning '#VALUE!'

Any idea what I'm doing wrong? it's formatted as a date.

CodePudding user response：

Here is what you can try using a formula,

• Formula used in cell F2

=DATE(MID(E2,FIND(",",E2) 2,4),MONTH(LEFT(E2,FIND(" ",E2)-1)&1),MID(E2,FIND(" ",E2) 1,2))

CodePudding user response：

Using Text-To-Columns:

• Select your data in E2:E10 or whatever row;
• Go to Text-To-Columns, then use Fixed Width;
• In the next screen remove all boundaries but keep the one that seperates the date from the timevalue;
• In the next screen choose to format the 1st column on Date 'MDY' and make sure that the destination is F2, also choose to Skip the 2nd column;
• Done.

If need be, format the data as general to show the integers only.