One mo
=IF(WEEKDAY(A1,2)5,"Y","")

And another:
=IF(WEEKDAY(A1,2)<6,"","Y")



The Rook wrote:

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.

--

Dave Peterson