Excel 2007 : Working days starting with Monday

How can I do in Excel 2007 to find out if the date in cell A1 is a working day. The working week starts on Monday and ends Friday. Saturday and Sunday are days off.

Hello andrugrasu,

Use WEEKDAY function

If the date is in A1, use this in B1. If the date in A1 Mon - Fri will give Workday, otherwise Week End.

=IF(WEEKDAY(A1,2)<=5,"Workday","Week End")

Or,

apply a custom cell format as,

ddd

This will show the date as Mon, Tue, Wed......