Using COUNTIF formula

[ngelbke]

I have an excel spreadsheet where I need to count the number of occurances where the date is over 3 days from current date. Is this possible? Or, do I have to put a < "current date" , and have to continually change it when I remove/add data?

Hope this makes sense! My first time posting on a forum.

Thanks,

Natalie

 

[VoG]

3 days greater that the current date or 3 days less than the current date?

 

[ngelbke]

Sorry, my bad. 3 days less. Here's a formula I came up with in which pulls data with a date 3 days less than 07/21/2012. As I use this sheet as a template and add/remove data - I don't want to have to go in to each individual formula daily and change the 3+ date. Please see below. Let me know your thoughts:

=COUNTIFS('All Lates - Data'!$F$2:$F$491, "FL", 'All Lates - Data'!$J$2:$J$491, "<7/18/2012")

 

[VoG]

Try

=COUNTIFS('All Lates - Data'!$F$2:$F$491, "FL", 'All Lates - Data'!$J$2:$J$491, "<" & TODAY()

 

[ngelbke]

Sorry, that didn't seem to work.

 

[T. Valko]

Sorry, that didn't seem to work.

Peter's formula is missing a closing parenthesis.

=COUNTIFS('All Lates - Data'!$F$2:$F$491,"FL",'All Lates - Data'!$J$2:$J$491,"<"&TODAY())

If that still doesn't work then how about posting some sample data and tell us what result you expect.

 

[ngelbke]

Got it, Thanks!!

 

[T. Valko]

Got it, Thanks!!

You're welcome!