WEEKDAY Function

From PlanFix
Jump to: navigation, search

The WEEKDAY function returns a number corresponding to the day of the week, from 1 (Monday) to 7 (Sunday).


Format:

*WEEKDAY(Column name or string with date)


Example:

IF(WEEKDAY(B)<6;"Workday";"Weekend")


Go To