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
Assigning a value to one cell based on the date in another... And then doing it again 0
Countif Formula 1
Countif, IF condition is met 2
Help with CountIF / SUM 1
If formula---adding another condition 6
Combining COUNTIF Criteria 4
need help in fine-tuning a formula that removes blank cells in a column range 3

Top