# COUNTIF function with Dates & due dates.

1. ## COUNTIF function with Dates & due dates.

I am trying to create a database with due dates for work. For Example.

Due in 7 Days =COUNTIF(A7:A40,"<="&TODAY()+7)-COUNTIF(A7:A40,"<"&TODAY())
Due in 30 Days =COUNTIF(A7:A40,"<="&TODAY()+30)-COUNTIF(A7:A40,"<"&TODAY())
Due in 60 Days =COUNTIF(A7:A40,"<="&TODAY()+60)-COUNTIF(A7:A40,"<"&TODAY())
Due in 90 Days =COUNTIF(A7:A40,"<="&TODAY()+90)-COUNTIF(A7:A40,"<"&TODAY())
Lapsed<Today =COUNTIF(A7:A40,"<"&TODAY())

I think these work for me in excel, but I'm not a master at this and for some reason when I read my functions I swear they are contradicting themselves. The reason I feel the functions contradict themselves is because I can remove the -countif and it still gets the same answer.

For the date ranges 90, 60, 30 & 7 I do not want dates counted that are less than "today" or ex. = a negative number. They would be considered "Lapsed"

Please see the attached file. Any help would be greatly appreciated!!!!!

Kevin

2. ## Re: COUNTIF function with Dates & due dates.

Hi,

in the example you attached, the second formula (i.e.: today()+30) refers to a different range A8:A41 instead of A7:A40.

Hope it helps

3. ## Re: COUNTIF function with Dates & due dates.

does this help?

4. ## Re: COUNTIF function with Dates & due dates.

Originally Posted by protonLeah
does this help?
Well it looks as though I was close, got the same numbers but set it up wrong. I like the true / false check. I'll put the formulas into my spreadsheet in the morning and hopefully it will all come together. I'll tag this solved once I do that. Thanks!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1