This is a project schedule format where I have list of dates and works. I need to color all the Sundays in list of dates and for that I will use a simple trick. Select all the dates then go…

WEEKDAY is a function which returns the day of the week corresponding to a date. from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. Syntax of the function is WEEKDAY(serial_number,[return_type]). serial_number is a sequential number in…

Tagged with: WEEKDAY

Top