dayOfWeek()

returns the day of the week of a particular date, where 1 = monday and 7 = sunday syntax dayofweek(date) parameters parameter type description date date docid\ xtaqdzvlbtakjxrnpfwe9 the date to get the day of week from return type number docid\ uci5tctfvbhonej6zqijg the day of the week for example, passing in a date that is on a monday will return 1 examples dayofweek('2025 05 12') returns 1 because monday, may 12, 2025 was a monday related carrot formatdate() docid\ sjkw09yi2eekuqemddoal can also be used to display the full name of the data such as " monday, may 12, 2025"