+ 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 365
    Posts
    134

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    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