+ Reply to Thread
Results 1 to 2 of 2

Add a date range search using From & To cells

  1. #1
    Forum Contributor
    Join Date
    05-14-2007
    Location
    London
    MS-Off Ver
    office 365
    Posts
    118

    Add a date range search using From & To cells

    Hi,

    So i have this formula

    =COUNTIF(leads!$M$3:leads!$M$1439,"Failed Credit Check")

    that counts instances in column M of a record sheet that has the date in column A

    what i would like is to run the formula but be able to select a date range by adding a from and to date in say cell $N1$ & $O$1

    so that rather than getting a count for all instances it only counts for the rows that have 'Failed Credit Check' in column M but in date range set in cells $N1$ & $O$1 for e.g 1/2/2021 - 28/2/21

    Thank you so much for your help here

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Add a date range search using From & To cells

    1. Please update your profile to show tyour approximate (national) geographical location.

    2. Please update your profile to show your current Excel version.

    3. Please re-read the rules. Why??

    We have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

    But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

    Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

    1) if you have cross-posted, and

    2) the URL of the cross posts.

    That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

    (Note: this requirement is not optional. No help to be offered until the link is provided AND your approximate location & Excel version have been provided..)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search in row range find first non empty cell bring value (date)2 cells above
    By Lephterisp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2019, 04:01 PM
  2. [SOLVED] Search Range of Cells for Text string and return latest Date
    By ajlogan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-15-2018, 08:30 AM
  3. [SOLVED] Search Range for NonBlank Cells, Fill Down only one cell below NOT all Blank cells belof
    By safari20WDG in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-07-2017, 01:23 AM
  4. Search large date range with narrow filetered range
    By druth in forum Excel General
    Replies: 14
    Last Post: 08-02-2014, 09:01 AM
  5. Modify this Search Formula to search across a range of cells
    By zicitron in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2013, 08:11 AM
  6. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  7. [SOLVED] search for part of date within range of cells
    By nsens in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-20-2013, 07:18 AM

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