Spreadsheet: 775077d1648809853-date-in-proper-date-format-date-format-formula-
Sheet: Sheet1

date | =INT method |  | But Actual Answer | Date | Date time
2020-10-05 21:30:00 |  | 2021-11-08 00:00:00 | 2000-05-10 00:00:00
17-05-2020 9:30 pm |  | 2021-08-17 00:00:00 | 2020-05-17 00:00:00 | #[NAME]! | #[NAME]!
18-05-2020 9:30 pm |  | 2021-08-22 00:00:00 | 2020-05-18 00:00:00 | #[NAME]! | #[NAME]!
2020-01-06 21:30:00 |  | 2021-08-29 00:00:00 | 2000-06-01 00:00:00 | 2020-01-06 00:00:00 | 2020-01-06 21:30:00
2020-02-06 21:30:00 |  | 2021-01-09 00:00:00 | 2020-06-02 00:00:00 | 2020-02-06 00:00:00 | 2020-02-06 21:30:00
26-07-2020 9:30 pm |  | 2021-05-09 00:00:00 | 2020-07-26 00:00:00 | #[NAME]! | #[NAME]!
27-07-2020 9:30 pm |  | 2021-05-09 00:00:00 | 2020-07-27 00:00:00 | #[NAME]! | #[NAME]!
2020-02-08 21:30:00 |  | 2021-07-09 00:00:00 |  | 2020-02-08 00:00:00 | 2020-02-08 21:30:00
2020-09-08 21:30:00 |  | 2021-09-26 00:00:00 |  | 2020-09-08 00:00:00 | 2020-09-08 21:30:00
2020-10-08 21:30:00 |  | 2021-04-10 00:00:00 |  | 2020-10-08 00:00:00 | 2020-10-08 21:30:00
16-08-2020 9:30 pm |  | 2021-06-10 00:00:00 |  | #[NAME]! | #[NAME]!
17-08-2020 9:30 pm |  | 2021-12-10 00:00:00 |  | #[NAME]! | #[NAME]!
18-08-2020 9:30 pm |  | 2021-12-10 00:00:00 |  | #[NAME]! | #[NAME]!
28-09-2020 9:30 pm |  | 2021-10-13 00:00:00 |  | #[NAME]! | #[NAME]!
2020-06-12 21:30:00 |  | 2021-10-17 00:00:00 |  | 2020-06-12 00:00:00 | 2020-06-12 21:30:00
31-01-2021 9:30 pm |  | 2021-10-18 00:00:00 |  | #[NAME]! | #[NAME]!
31-01-2021 9:30 pm |  | 2021-10-20 00:00:00 |  | #[NAME]! | #[NAME]!
2021-01-02 21:30:00 |  | 2021-10-24 00:00:00 |  | 2021-01-02 00:00:00 | 2021-01-02 21:30:00
2021-01-02 21:30:00 |  | 2021-10-25 00:00:00 |  | 2021-01-02 00:00:00 | 2021-01-02 21:30:00
2021-02-02 21:30:00 |  | 2021-10-25 00:00:00 |  | 2021-02-02 00:00:00 | 2021-02-02 21:30:00
2021-03-02 21:30:00 |  | 2021-08-11 00:00:00 |  | 2021-03-02 00:00:00 | 2021-03-02 21:30:00
2021-07-03 21:30:00 |  | 2021-11-11 00:00:00 |  | 2021-07-03 00:00:00 | 2021-07-03 21:30:00
21-03-2021 9:30 pm |  | 2021-06-12 00:00:00 |  | #[NAME]! | #[NAME]!
2021-09-05 21:30:00 |  | 2021-06-12 00:00:00 |  | 2021-09-05 00:00:00 | 2021-09-05 21:30:00
2021-10-05 21:30:00 |  | 2021-06-12 00:00:00 |  | 2021-10-05 00:00:00 | 2021-10-05 21:30:00
2021-12-09 21:30:00 |  | 2021-06-12 00:00:00 |  | 2021-12-09 00:00:00 | 2021-12-09 21:30:00
21-11-2021 9:30 pm |  | 2021-12-12 00:00:00 |  | #[NAME]! | #[NAME]!
22-11-2021 9:30 pm |  | 2021-12-15 00:00:00 |  | #[NAME]! | #[NAME]!
2021-05-12 21:30:00 |  | 2021-12-19 00:00:00 |  | 2021-05-12 00:00:00 | 2021-05-12 21:30:00
19-12-2021 9:30 pm |  | 2021-12-20 00:00:00 |  | #[NAME]! | #[NAME]!
20-12-2021 9:30 pm |  | 2021-12-28 00:00:00 |  | #[NAME]! | #[NAME]!
21-12-2021 9:30 pm |  | 2022-02-01 00:00:00 |  | #[NAME]! | #[NAME]!
20-02-2022 9:30 pm |  | 2022-09-01 00:00:00 |  | #[NAME]! | #[NAME]!
21-02-2022 9:30 pm |  | 2022-11-01 00:00:00 |  | #[NAME]! | #[NAME]!
21-02-2022 9:30 pm |  | 2022-01-13 00:00:00 |  | #[NAME]! | #[NAME]!
22-02-2022 9:30 pm |  | 2022-01-16 00:00:00 |  | #[NAME]! | #[NAME]!
2022-06-03 21:30:00 |  | 2022-01-19 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-01-24 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-01-31 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-01-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-01-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-01-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-01-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-03-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-06-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-06-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-08-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-08-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-08-02 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-02-13 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-02-22 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-02-22 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-02-22 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-03-14 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-03-20 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  | 2022-03-22 00:00:00 |  | 2022-06-03 00:00:00 | 2022-06-03 21:30:00
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-06-03 21:30:00 |  |  |  | 44715 | 44715.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-07-03 21:30:00 |  |  |  | 44745 | 44745.89583333334
2022-08-03 21:30:00 |  |  |  | 44776 | 44776.89583333334
2022-08-03 21:30:00 |  |  |  | 44776 | 44776.89583333334
2022-08-03 21:30:00 |  |  |  | 44776 | 44776.89583333334
2022-08-03 21:30:00 |  |  |  | 44776 | 44776.89583333334
2022-09-03 21:30:00 |  |  |  | 44807 | 44807.89583333334
27-03-2022 9:30 pm |  |  |  | #[NAME]! | #[NAME]!
28-03-2022 9:30 pm |  |  |  | #[NAME]! | #[NAME]!
28-03-2022 9:30 pm |  |  |  | #[NAME]! | #[NAME]!
28-03-2022 9:30 pm |  |  |  | #[NAME]! | #[NAME]!
30-03-2022 9:30 pm |  |  |  | #[NAME]! | #[NAME]!