Question

to enter date time together separate them with a


​

Answer 1

Answer:

If a cell contains a combined date and time, you can use the INT function to pull the time value into a separate column. Dates are stored as numbers in Excel, with the decimal portion representing the time. The formula should automatically fill down to the last row in the table.

Answer 2

Answer:

Explanation:

1) select the cell B1 and write the formula to extract date from. Cell A1.

2)=INT(A1),press enter.

3)Format this cell as "mm/dd/yyyy".

4)To format the cell, press the key "CTRL+1".

5)Format the cell dialog box will appear.