Converting Dates into Seasons

baumisf

New Member
Joined
Sep 30, 2009
Messages
2
Hey,

I have a list of dates, and would like to transform them into seasons (0=Winter, 1=Spring, 2=Summer, 3=Fall)

do you know how to do this?
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi & Welcome to the Board!

Please can you define from and to dates for all your seasons so that we can provide a solution. Thanks!
 

baumisf

New Member
Joined
Sep 30, 2009
Messages
2
thanks for your quick reply:

the datas are in the following format:
Day.Monty.Year (24.22.08) -> all dates are from 2008, German format

I want them to be converted into:
0 for Dates between 01.01.08 to 28.02.08 + 01.12.08 - 31.12.08
1 for Dates between 01.03.08 to 31.05.08
2 for Dates between 01.06.08 to 31.08.08
3 for Dates between 01.09.08 to 30.11.08

Thanks again and I am excited about your suggestions
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Assuming those dates are recognised by Excel as dates (they wouldn't with my Regional Settings as Iam in the UK) then I think the absoulte simplest way of doing this is

=INT(MOD(MONTH(A1),12)/3)
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
If you have your date in A2 this formula should convert it as you specified

=IF(A2="","",CHOOSE(MONTH(A2),0,0,1,1,1,2,2,2,3,3,3,0))
 

Watch MrExcel Video

Forum statistics

Threads
1,118,099
Messages
5,570,207
Members
412,308
Latest member
jt145
Top