Function reference
Gets the day of the week of a date value and returns the number of the weekday.

DayNumber ( date )

Argument Description
date The date from which you want the number of the day of the week.

value1 > value2

Data type: Integer
Returns an integer (1–7) representing the day of the week of date. Sunday is day 1, Monday is day 2, and so on.


This expression returns Wrong Day if the date in [data] is not a Sunday or a Monday:
If ( DayNumber( Date([data]) ) > 2 , “Okay” , “Wrong Day” )

Last modified: 23 May 2021