Take advantage of the DATE function
Would you like to know on which day of the week New Year's Day will fall next year? Or what about your birthday? Determining which day of the week a date will be may sound easy, but it can get tricky.
Excel's DATE function can make this process painless. Using this function and custom formatting, you can create a worksheet that returns the day of the week for any date.
Follow these steps:
To find the day of the week for the next New Year's Day, enter 1 in A2, enter 1 in B2, and enter 2005 in C2. B5 will display Saturday. (By the way, the entry for Month must be the number for the month, not the name.)