Description
Used to return the serial number day within the week (1-7) for the given date. The WEEKDAY function can be useful in various nested functions and can provide input for functions while excel modeling.
Remember not to confuse WEEKDAY with WEEKNUM function, in which Excel return Serial number of the week with in a year.
=WEEKDAY(serial_number,return_type)
The WEEKDAY function syntax has the following argument:
- Serial_Number Required.
The date of the day you are trying to find.
- Return_type Optional.
A number that determines on which day the week begins. The default is 1 (Monday)
Note: Avoid directly punching dates into Excel function, instead of either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel will read the date as ZERO.
