Formula with date ranges

[sunrise06]

I have a long column of dates that I want to segment by year. For example, =IF(AND(C2>=8/1/2018,C2<=7/30/2019),"2018-2019",""). This will give me for one year, but how do I write the formula for say a 10 year span of dates so that 8/1/2017<>7/30/2018 will then give me 2017-2018, etc?

 

[Jeffrey Mahoney]

You will need to continue on the same line of thought and create a nested if statement:
=IF(AND(C2>=8/1/2018,C2<=7/30/2019),"2018-2019",AND(C2>=8/1/2017,C2<=7/30/2018),"2017-2018","")
And so on...

 

[sunrise06]

Thanks, I am getting an error - You've entered too many arguments for this function.

 

[GR00007]

Here's another thought that formats the range based on relative position from August 1st.
=IF(0 < DAYS(DATE(YEAR(C2),8,1),C2),TEXT(YEAR(C2) -1,"####")&"-"&TEXT(YEAR(C2),"####"),TEXT(YEAR(C2),"####")&"-"&TEXT(YEAR(C2)+1,"####"))

 

[sunrise06]

Awesome! Thanks!

 

[Jeffrey Mahoney]

Forgot to add the IF portion

=IF(AND(C2>=8/1/2018,C2<=7/30/2019),"2018-2019",IF(AND(C2>=8/1/2017,C2<=7/30/2018),"2017-2018",""))