Countif only after specified date

  • Thread starter Thread starter hmsawyer
  • Start date Start date
H

hmsawyer

I have this formula:

=IF(COUNTIF('Employee Attendance'!3:3,">="&DATE(2008,4,1)) -
COUNTIF('Employee Attendance'!3:3,">="&DATE(2008,5,1))>0,"No","Yes")

I would like it to keep the cells blank and only complete the calculation
after 4/31/08. Any ideas? Thank you!
 
Back
Top