DAY Function not working as intended?
I have a column formula for the "Month" "Day" and "Week" from the "Auto - Date Added" Column
The column formula for DAY is
=DAY([Auto - Date Added]@row)
As you can see, the day is still the same - 7/14/22 but the day function goes to the next day (15th) after 5PM. Is there anyway to fix this / change the day function so that is interprets the day to be started at 12AM and not 5PM?
Would be much appreciated..
Help Article Resources
Check out the Formula Handbook template!