+ Reply to Thread
Results 1 to 4 of 4

Using COUNTIFS with date ranges

  1. 04-23-2013, 09:38 PM #1
    Harrytheb is offline
    Registered User
    Join Date
    04-23-2013
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    Using COUNTIFS with date ranges

    Greetings, I am trying to count the number of date entries in a column that fall within the range of today to today - 30 days. Sounds simple but I seem to have got the syntax wrong, can anyone help? Thanks in advance. H
    Reply With QuoteRegister To Reply
  2. 04-23-2013, 09:48 PM #2
    Lemice is offline
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Using COUNTIFS with date ranges

    Hello,

    Assuming your range of date entries is in A1 to A25, use this one
    Please Login or Register  to view this content.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem
    Reply With QuoteRegister To Reply
  3. 04-24-2013, 12:11 PM #3
    Harrytheb is offline
    Registered User
    Join Date
    04-23-2013
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Using COUNTIFS with date ranges

    Hi Lem,
    Thanks a lot for the reply, worked fine! Also used TODAY which works too!

    H

    Quote Originally Posted by Lemice View Post
    Hello,

    Assuming your range of date entries is in A1 to A25, use this one
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 04-24-2013, 12:17 PM #4
    Lemice is offline
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Using COUNTIFS with date ranges

    Glad I could help. Thank you for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1