+ Reply to Thread
Results 1 to 4 of 4

If date falls between two dates then return true

  1. #1
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    If date falls between two dates then return true

    Hi,

    I need a formula in column that if a date in range A3:A32 falls between the dates entered in A1:A2, to return true otherwise leave blank.

    I've attached a mock up of what I want.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 2013
    Posts
    118

    Re: If date falls between two dates then return true

    Hi.. Please try below formula in B3

    =IF(AND(A3>=$A$1,A3<=$A$2),"True","")

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,869

    Re: If date falls between two dates then return true

    Like this (two options):

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    1
    05/06/2017
    2
    18/06/2017
    3
    01/06/2017
    FALSE
    4
    02/06/2017
    FALSE
    5
    03/06/2017
    FALSE
    6
    04/06/2017
    FALSE
    7
    05/06/2017
    TRUE
    TRUE
    TRUE
    8
    06/06/2017
    TRUE
    TRUE
    TRUE
    9
    07/06/2017
    TRUE
    TRUE
    TRUE
    10
    08/06/2017
    TRUE
    TRUE
    TRUE
    11
    09/06/2017
    TRUE
    TRUE
    TRUE
    12
    10/06/2017
    TRUE
    TRUE
    TRUE
    13
    11/06/2017
    TRUE
    TRUE
    TRUE
    14
    12/06/2017
    TRUE
    TRUE
    TRUE
    15
    13/06/2017
    TRUE
    TRUE
    TRUE
    16
    14/06/2017
    TRUE
    TRUE
    TRUE
    17
    15/06/2017
    TRUE
    TRUE
    TRUE
    18
    16/06/2017
    TRUE
    TRUE
    TRUE
    19
    17/06/2017
    TRUE
    TRUE
    TRUE
    20
    18/06/2017
    TRUE
    TRUE
    TRUE
    21
    19/06/2017
    FALSE
    22
    20/06/2017
    FALSE
    23
    21/06/2017
    FALSE
    24
    22/06/2017
    FALSE
    25
    23/06/2017
    FALSE
    26
    24/06/2017
    FALSE
    27
    25/06/2017
    FALSE
    28
    26/06/2017
    FALSE
    29
    27/06/2017
    FALSE
    30
    28/06/2017
    FALSE
    31
    29/06/2017
    FALSE
    32
    30/06/2017
    FALSE
    Sheet: Sheet1
    Excel 2016 (Windows) 32 bit
    C
    D
    3
    =AND(A3>=$A$1,A3<=$A$2)
    =IF(AND(A3>=$A$1,A3<=$A$2),TRUE,"")
    Sheet: Sheet1
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,834

    Re: If date falls between two dates then return true

    tRY

    b3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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. [SOLVED] VLOOKUP to Return Value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-23-2016, 12:38 PM
  2. VLOOKUP to return value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2016, 11:49 AM
  3. VLOOKUP to return value if date falls between two dates
    By Cdubisms in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2016, 11:48 AM
  4. HELP: Return a value with a date that falls between two other dates
    By hionman in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-18-2014, 08:01 AM
  5. [SOLVED] Looking for formula to return a date that falls between 2 dates
    By cobo1981 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-13-2014, 01:12 PM
  6. Return True or False if date range falls within current month
    By kieran614 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 12:02 PM
  7. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 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