How to get the weekday number and day of the week from a date in Excel. Examples with syntax including how to use the WEEKDAY() and TEXT() functions and errors to watch out for.