The WEEKDAY function in Excel takes a date and returns a number between 1 to 7 representing the day of the Week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday. The WEEKDAY function can be used inside other formulas to check the day of the Week.

Join my online course on Excel Tables
https://www.udemy.com/course/tables-in-excel/?referralCode=692FAFD07AA4149E96D0

Download my free eBook on Excel Macros
http://eepurl.com/gpT0RD

Check these Books on Excel
https://xlncad.com/excel-resources/

Read my articles on Excel
https://xlncad.com/

Playlist for Shorts on Excel
https://www.youtube.com/playlist?list=PLOpSTK2dKjqJYObfdAjr6Xhv-GMigo7Kx

#excelshorts #exceltip #exceltrick

Please take the opportunity to connect and share this video with your friends and family if you find it useful.