Thread: If formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmsawyer hmsawyer is offline
external usenet poster
 
Posts: 33
Default If formula

This formula is not working. Can you please help me correct it?

=IF(AND('Employee Attendance'!3:3DATEVALUE("4/1/08"),'Employee
Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes")

If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it
to return as blank. If false (no date in that range), then I want it to
return "Yes".


Thank you.