Find IF date between, TRUE

**vcxzvcxz** · 10-12-2017, 11:05 AM

Hi, I'm trying to write a formula that references a that contains a date, determines whether or not that date falls between two dates, and returns a value if TRUE. I'm planning on nesting this statement for 3 ranges of dates. but here is the first one. I haven't been able to get it to work yet.

=IF(M8(AND(Date>6/30/2015,Date<7/1/2016),"FY16"))

This was the first version I tried that also didn't work, but shows the nesting and date ranges required:

=IF(M8>"Jun-15"<"Jul-16","FY16",IF(M8>"Jun-16"<"Jul-17","FY17",IF(M8>"Jun-17"<"Jul-18","FY18")

Anyone have any ideas? Thanks!

**davesexcel** · 10-12-2017, 11:07 AM

Normally to see if something is between using the and()

Formula:

Please Login or Register  to view this content.

**kev_** · 10-12-2017, 11:18 AM

with date being tested in B1, the earlier date in B2, the later date in B3
=AND(B1>=B2,B1<=B3)
returns a TRUE or FALSE in cell B1 for dates within the range B2 to B3

**Glenn Kennedy** · 10-12-2017, 11:19 AM

.. or hard coded into the formula:

=IF(AND(D2>DATE(2015,6,30),D2< DATE(2016,7,1)),"FY16","")

**kev_** · 10-12-2017, 11:20 AM

post duplicated somehow??
deleted by kev

Find IF date between, TRUE

LinkBack

Thread Tools

Rate This Thread

Display

Find IF date between, TRUE

Re: Find IF date between, TRUE

Re: Find IF date between, TRUE

Re: Find IF date between, TRUE

Re: Find IF date between, TRUE

Thread Information

Users Browsing this Thread

Similar Threads

find out the maximum date from all true values

If month and year of a date in a range of dates matches a specific date, return true

[SOLVED] If find = true then.... else.... end if

[SOLVED] Formula to return a True/False if date equals yesterday's date

If find is true then.....

[SOLVED] VB find (true false)

Date help, if selected date is saturday then expression returns true

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions