Excel 2007 : IF functions with Date ranges

**ortiz718** · 04-30-2010, 01:01 PM

Is there any formula that I can use when working with a specific date range and if someone's birthday falls in that range a certain text or value would be displayed? For example I want to create a spreadsheet for my soccer players and have them sorted into teams according to their birthdays. So if their birthday falls into the following date range: 08/01/05-07/01/07 a U-8 or U-10 would be displayed in the corresponding cell. I tried working with the IF function, but I got no where. Please help. Thank You.

**NBVC** · 04-30-2010, 02:20 PM

e.g.

=IF(AND(A1>="08/01/05"+0),(A1<="07/01/07"+0),"U-8","U-10")

So if date is in range U-8 displayed, else U-10 is displayed.

Is that what you mean?

**ortiz718** · 04-30-2010, 05:58 PM

yes that is exactly what I mean, thank you...

**korothnlr** · 07-14-2013, 05:31 PM

This is what I was searching for! Thanks allot...

**swapsarkar** · 01-24-2014, 03:20 PM

.....while I was going through the subject 'IF functions with Date ranges', a small syntax error caught my attention.... .....the correct syntax would be: =IF(AND(A1>="08/01/05"+0,A1<="07/01/07"+0),"U-8","U-10") .....and this will give the desired output....the additional two brackets given in your syntax will mislead the AND function.....