Recently, after demonstrating the use of TODAY() function which will update on a daily basis, I was asked how I could see what day of the week it is. The WEEKDAY function can be used to help here, along with a bit of custom formatting.
The syntax for the WEEKDAY function is =WEEKDAY(serialnumber, return type), where serialnumber is a number between 1 and 7 and the return type, the most common ones being 1 which goes from Sunday through to Saturday and 2 which goes from Monday to Sunday.
If you type in =WEEKDAY(TODAY(),1) then go to the Format Cells dialog box, Number tab, click Custom, then type in dddd.
The result will be today’s day of the week.
Find more information about Microsoft Excel training Sydney.