More compact, but much less obvious<g...

=IF(MOD(A1,7)<2,"Y","")

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Give this a try...

=IF(WEEKDAY(A1,3)4,"Y","")

Rick


"The Rook" wrote in message
...
I have a list of dates in column A and would like to populate column B
with
either 1 or Y is the date is a sat or a sun.