SOLUTIONS
Column 1: Date that you want to format (use a date column)
Column 2: In row 1 add this date January 1, 1900 at 12:00 PM (use date column)
Column 3: Single Value on column 2 (single value column)
Column 4: Column 1 minus Column 3 (use math column for this)
Column 5: Column 3 Plus Column 4 (use math column for this)
I was able to use column 4 for my specific problem but the column 5 give a nice way to display the date. (plus many other uses i’m sure)