View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmsawyer hmsawyer is offline
external usenet poster
 
Posts: 33
Default Countif only after specified date

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!