Separating Date & Time for Function

Hello, dsmith5740 

In addition, you can use Power Query to Separate the Date & Time

Click anywhere in the data and execute CTRL + T

Check my table has headers and click OK

In the Get & Transform, click on From Table

In the Power Query editor, click on Split Column in the Home tab

Select By Delimiter

Select Space from the drop-down

Check Left-most delimiter

Click OK. From the caption below, we have the date and time splited into two columns

Then, you can choose Close & Load to load the result back to excel