Created (Date) & weekday formula
I've created a form that has a date/time stamp i.e. "created (date)" value. That value is automatically added to my sheet and I would like to create an automation that sends an email if the request is submitted on a weekend. I'm trying to use the weekend function but it is behaving strangely.
There is a date of 5/10/21 5:50pm that the weekday function is somehow recognizing as a Tuesday. It is my understanding that it begins with Sunday as a 1 and so on, which would make 5/10 a 2. I could sort of understand if it was based on the servers being on EST and the time was after 9pm but that's not the case.
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!