Thread: IF and Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DAS DAS is offline
external usenet poster
 
Posts: 26
Default IF and Date

Hey crew, I'm a little rusty and need some refresher...

In column A I have the dates in =Date(yyyy,mm,dd) format

In column B, I am want the cells to say "OFF" if the day is equal to
Sunday or Monday for instance.

Right now I'm using this formula for Sunday:

=IF(DAY(7)=A4,"OFF","")

Which isn't working. I just can't remember the exact way to do it.

Thanks for your help.