I am needing to find the number of days from column 'D' 'Creation Date' to column 'Q' 'Class Start Date'. This formula can be placed in the column 'AY'. The issue using DATEIF is the formatting in column 'D2'. It is displayed as ##:##.#, but is 1/23/2023 6:22:47 AM and if I format the cell as Number > Date, I am still unable to calculate the date difference. Is there a formula or a macro that can do this?