I'm trying to make a formula that takes a date formatted like this
"10/7" and will spit out the date 3 days before it.
So I make a formula
and that spits out the date. However, I also want there to be a pre-determined time following the sheet which is "09:00"
However, when I input a date of 10/10 in C79 and use this formula
I get an output of "433800.375"
What part of the formula is incorrect here?