Days of the week conditions

Katie - Jan 26, 2016 at 09:25 AM
 Blocked Profile - Jan 26, 2016 at 03:45 PM

I am trying to create a template for my work. I have a table sorted by dates but need to reference the day of the week that date falls on. If the date falls on Sunday-Wednesday I need the value to be "X" if it falls on Thursday-Saturday I need it to be "Y". Is excel smart enough to recognize days of the week from a date format? And what formula would I use to accomplish this result?

1 response

Blocked Profile
Jan 26, 2016 at 03:45 PM
Try weekday(cell_reference). it return 1 for Sunday, and. 7 for Saturday!