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!
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!
Hi.. Please try below formula in B3
=IF(AND(A3>=$A$1,A3<=$A$2),"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 Excel 2016 (Windows) 32 bit
Sheet: Sheet1
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.
tRY
b3Formula: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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks