Results 1 to 3 of 3

Thread: countif dates

  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Have a column B with dates. Want to count the rows with dates that fall in the last 14 days. Tried formula:
    =COUNTIF($B6:$B$100,"<now()-14")

    Counts zero. Need corrected formula

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How about:

    =COUNTIF($B6:$B$95,">"&NOW()-14)-COUNTIF($B6:$B$95,">"&NOW())

    Steve

  3. #3
    Star Lounger
    Join Date
    Feb 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts
    That works, Thank you.

Posting Permissions

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