Spreadsheet: 863273d1710834127-combining-two-dates-formula-using-if-condition-combining-two-formula-using-if-condition-1-aligw
Sheet: Sheet2

Date with General [NAME] (DDMMYYYY) | Remove "/" | Add leading zeros | MM/DD/YYYY (Final) | [NAME] | [NAME]/dd/yyy
30/11/2025 |  |  |  |  | 30/11/2025
20/12/2022 |  |  |  |  | 20/12/2022
30/4/2026 |  |  |  |  | 30/4/2026
31/8/2025 |  |  |  |  | 31/8/2025
1/1/2099 |  |  |  |  | 2099-01-01 00:00:00
14/6/2024 |  |  |  |  | 14/6/2024
30/6/2024 |  |  |  |  | 30/6/2024
30/6/2020 |  |  |  |  | 30/6/2020
31/12/2027 |  |  |  |  | 31/12/2027
1/1/1900 |  |  |  |  | 1900-01-01 00:00:00
7/6/2024 |  |  |  |  | 2024-07-06 00:00:00
10/1/2025 |  |  |  |  | 2025-10-01 00:00:00
31/12/2024 |  |  |  |  | 31/12/2024
30/6/2025 |  |  |  |  | 30/6/2025
31/8/2012 |  |  |  |  | 31/8/2012
15/6/2022 |  |  |  |  | 15/6/2022
8/1/2030 |  |  |  |  | 2030-08-01 00:00:00
12/7/2022 |  |  |  |  | 2022-12-07 00:00:00
9/4/2024 |  |  |  |  | 2024-09-04 00:00:00
14/10/2025 |  |  |  |  | 14/10/2025
13/1/2032 |  |  |  |  | 13/1/2032
23/3/2027 |  |  |  |  | 23/3/2027
4/10/2026 |  |  |  |  | 2026-04-10 00:00:00
[NAME] |  |  |  |  | 2022-10-11 00:00:00
8/8/2023 |  |  |  |  | 2023-08-08 00:00:00
31/1/2023 |  |  |  |  | 31/1/2023
13/4/2027 |  |  |  |  | 13/4/2027
14/7/2026 |  |  |  |  | 14/7/2026
11/1/2033 |  |  |  |  | 2033-11-01 00:00:00
30/11/2023 |  |  |  |  | 30/11/2023
10/4/2029 |  |  |  |  | 2029-10-04 00:00:00
12/10/2021 |  |  |  |  | 2021-12-10 00:00:00
30/9/2016 |  |  |  |  | 30/9/2016
30/4/2020 |  |  |  |  | 30/4/2020
30/9/2021 |  |  |  |  | 30/9/2021
29/7/2024 |  |  |  |  | 29/7/2024
30/11/2026 |  |  |  |  | 30/11/2026
30/9/2015 |  |  |  |  | 30/9/2015
30/9/2023 |  |  |  |  | 30/9/2023
31/12/2022 |  |  |  |  | 31/12/2022
31/10/2024 |  |  |  |  | 31/10/2024
12/10/2027 |  |  |  |  | 2027-12-10 00:00:00
9/7/2024 |  |  |  |  | 2024-09-07 00:00:00
30/6/2022 |  |  |  |  | 30/6/2022
9/1/2029 |  |  |  |  | 2029-09-01 00:00:00
14/7/2020 |  |  |  |  | 14/7/2020
12/12/2021 |  |  |  |  | 2021-12-12 00:00:00
1/6/2025 |  |  |  |  | 2025-01-06 00:00:00
31/12/2023 |  |  |  |  | 31/12/2023
31/7/2024 |  |  |  |  | 31/7/2024
18/12/2024 |  |  |  |  | 18/12/2024
20/9/2018 |  |  |  |  | 20/9/2018
31/7/2021 |  |  |  |  | 31/7/2021
11/4/2023 |  |  |  |  | 2023-11-04 00:00:00
10/4/2018 |  |  |  |  | 2018-10-04 00:00:00
12/4/2016 |  |  |  |  | 2016-12-04 00:00:00
31/12/2030 |  |  |  |  | 31/12/2030
31/3/2022 |  |  |  |  | 31/3/2022
31/1/2015 |  |  |  |  | 31/1/2015
31/7/2019 |  |  |  |  | 31/7/2019
2/4/2025 |  |  |  |  | 2025-02-04 00:00:00
12/1/2027 |  |  |  |  | 2027-12-01 00:00:00
10/10/2023 |  |  |  |  | 2023-10-10 00:00:00
31/5/2029 |  |  |  |  | 31/5/2029
30/11/2020 |  |  |  |  | 30/11/2020
31/1/2019 |  |  |  |  | 31/1/2019
31/12/2020 |  |  |  |  | 31/12/2020
1/8/2025 |  |  |  |  | 2025-01-08 00:00:00
31/3/2024 |  |  |  |  | 31/3/2024
31/12/2025 |  |  |  |  | 31/12/2025
30/6/2030 |  |  |  |  | 30/6/2030
28/2/2023 |  |  |  |  | 28/2/2023
31/10/2023 |  |  |  |  | 31/10/2023
29/1/2021 |  |  |  |  | 29/1/2021
1/1/2031 |  |  |  |  | 2031-01-01 00:00:00
16/4/2026 |  |  |  |  | 16/4/2026
1/4/2030 |  |  |  |  | 2030-01-04 00:00:00
14/1/2025 |  |  |  |  | 14/1/2025
30/6/2026 |  |  |  |  | 30/6/2026
28/2/2026 |  |  |  |  | 28/2/2026
31/8/2027 |  |  |  |  | 31/8/2027
28/2/2025 |  |  |  |  | 28/2/2025
31/10/2025 |  |  |  |  | 31/10/2025
28/2/2027 |  |  |  |  | 28/2/2027
15/7/2026 |  |  |  |  | 15/7/2026