Have a look in HELP index for WEEKDAY

--
Don Guillett
SalesAid Software

"tamato43" wrote in message
...
If the cell is formatted to show a date as follows:

"Monday 3/21/2005"

How can I create a "SUMIF" condition to say".....

SUMIF "Monday" shows anywhere in the cell.