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.

Example:

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” )

Need more help with this?
Don’t hesitate to contact us here.

Thanks for your feedback.