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!