[SOLVED] IF function with multiple scenarios-determining the current season

Hello,

I have 4 dates-21/3/10, 21/6/10,21/9/10 and 21/12/10. These are all the start of the seasons.

I need a formula that can determine the current season (my boss requires it in a spreadsheet and considers it quite important ). I'm OK with usual IF functions but this one has 4 different outcomes and is a bit sticky. I have tried =IF(TODAY()<"21/3/10";"WINTER";"");IF(TODAY()>"21/3/10"<21/6/10";"SPRING";"" and this is as far as i tested but this didn't seem to work so i'm just wondering how to properly put this all together.


Thanks guys

You could set up a small table with your dates in A1:A4 (for example) and seasons in B1:B4. Then your formula would be

=VLOOKUP(TODAY(),$A$1:$B$4,2,TRUE)

If there was the possibility that today was before the value in A1, you'd need to include Jan 1,2010 as the first value (Winter) making it a 2 x 5 table. Make sense?

If you really want to use IF statements, you'll need to express your dates as numbers, not strings and use the AND function.

Hi,

If you did want an if then perhaps

=IF(TODAY()<DATE(YEAR(TODAY()),3,21),"Winter",IF(TODAY()<DATE(YEAR(TODAY()),6,21),"Spring",IF(TODAY()<DATE(YEAR(TODAY()),9,21),"Summer",IF(TODAY()<DATE(YEAR(TODAY()),12,21),"Autumn","Winter"))))