Thread
:
Weekend
View Single Post
#
5
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_660_]
external usenet poster
Posts: 1
Weekend
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.
Reply With Quote
Rick Rothstein \(MVP - VB\)[_660_]
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)[_660_]