Countif only after specified 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula 8
If formula---adding another condition 6
COUNTIF between dates and if value = "y" 8
IF, COUNTIF & AND STATEMENTS 3
CountIf to determine Date - 3 yrs 3
COUNTIF Function 3
using worksheet name in a formula but not current worksheet 3
CONDITIONAL COUNTIF FUNTIONS PLEASE HELP!!! 8

Top