# If date falls between two dates then return true

1. ## 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.

2. ## 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. ## 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

4. ## Re: If date falls between two dates then return true

tRY

b3
Formula:
`Please Login or Register  to view this content.`

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

#### 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