DATETIME_DIFF({Sell}, {Buy Date} 'days')

[GGA]

why does a 'day date' formula, based on a 'start time' return a day as the day before, when the start time is before 8am? 

Here is my formula column which is based on my start day/time field

DATETIME_FORMAT(Start,"D-ddd")

[TheTimeSavingCo · Accepted solution]

Probably a timezone thing; try setting your "Start" day/time field to use the same timezone for all collaborators and see if your formula field updates correctly?

[GGA]

That was it! Thank you - I was set to USA time but I am in Australia 🙂