+ Reply to Thread
Results 1 to 4 of 4

COUNTIF function with Dates & due dates.

  1. #1
    Registered User
    Join Date
    03-09-2011
    Location
    Brooklyn, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    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
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    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
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: COUNTIF function with Dates & due dates.

    does this help?
    Attached Files Attached Files
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    03-09-2011
    Location
    Brooklyn, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: COUNTIF function with Dates & due dates.

    Quote Originally Posted by protonLeah View Post
    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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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