Thread: Weekend
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_660_] Rick Rothstein \(MVP - VB\)[_660_] is offline
external usenet poster
 
Posts: 1
Default 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.