Spreadsheet: 736113d1623353733-how-to-separate-months-and-seasons-from-daily-data-daily_data-2-
Sheet: expected results

Date | PRECTOT | RH2M | [NAME] | T2M_MAX | [NAME] |  | Discription | Function | Result |  | Date | hot days | cold days | hot nights | cold nights |  | year | Winter |  |  |  | Spring |  |  |  | Summer |  |  |  | Autumn |  |  |  |  | year | January |  |  |  | February |  |  |  | March |  |  |  | April |  |  |  | May |  |  |  | June |  |  |  | July |  |  |  | August |  |  |  | September |  |  |  | October |  |  |  | November |  |  |  | December
1/3/1982 | 0.01 | 52.77 | 12.98 | 19.81 | 7.91 |  | Hot days | 90% | 34.96 |  |  |  |  |  |  |  |  | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights |  |  | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights | No. of hot days | No. of cold days | No. of hot nights | No. of cold nights
2/3/1982 | 0.9 | 69.34 | 12.4 | 18.17 | 7.97 |  | Cold days | 0.1 |  |  |  |  |  |  |  |  | 1982 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1982
3/3/1982 | 0.13 | 57.12 | 13.42 | 20.29 | 7.89 |  | Hot Nights | 0.9 |  |  |  |  |  |  |  |  | 1983 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1983
4/3/1982 | 0.03 | 44.72 | 15.16 | 23.21 | 7.68 |  | Cold Nights | 0.1 |  |  |  |  |  |  |  |  | 1984 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1984
5/3/1982 | 1.92 | 62.25 | 14.54 | 20.84 | 9.12 |  |  |  |  |  |  |  |  |  |  |  | 1985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1985
6/3/1982 | 0.01 | 65.97 | 14.51 | 21.43 | 9.34 |  |  |  |  |  |  |  |  |  |  |  | 1986 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1986
7/3/1982 | 0 | 60.37 | 14.95 | 23.02 | 7.84 |  | No. of Hot Days |  |  |  |  |  |  |  |  |  | 1987 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1987
8/3/1982 | 0.05 | 57.35 | 14.89 | 23.76 | 8.08 |  | No. of Cold Days |  |  |  |  |  |  |  |  |  | 1988 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1988
9/3/1982 | 2.16 | 72.59 | 13.46 | 18.22 | 9.91 |  | No. of Hot Nights |  |  |  |  |  |  |  |  |  | 1989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1989
10/3/1982 | 0.34 | 69.06 | 12.83 | 18.58 | 8.89 |  | No. of Cold Nights |  |  |  |  |  |  |  |  |  | 1990 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1990
11/3/1982 | 0.02 | 57.68 | 13.08 | 18.64 | 7.74 |  |  |  |  |  |  |  |  |  |  |  | 1991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1991
12/3/1982 | 0.02 | 47.81 | 14.35 | 21.94 | 6.91 |  | Month | Season |  |  |  |  |  |  |  |  | 1992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1992
13/3/1982 | 0.71 | 62.26 | 13.82 | 18.91 | 10.41 |  | 1 | Winter |  |  |  |  |  |  |  |  | 1993 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993
14/3/1982 | 0.03 | 63.21 | 14.35 | 20.29 | 10.12 |  | 2 | Winter |  |  |  |  |  |  |  |  | 1994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994
15/3/1982 | 0 | 61.98 | 14.05 | 20.26 | 9.09 |  | 3 | Spring |  |  |  |  |  |  |  |  | 1995 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1995
16/3/1982 | 0.08 | 61.57 | 14.93 | 22.69 | 8.61 |  | 4 | Spring |  |  |  |  |  |  |  |  | 1996 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1996
17/3/1982 | 0 | 56.96 | 14.27 | 20.21 | 9.48 |  | 5 | Spring |  |  |  |  |  |  |  |  | 1997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1997
18/3/1982 | 0 | 57.93 | 13.64 | 20.72 | 8.22 |  | 6 | Summer |  |  |  |  |  |  |  |  | 1998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1998
19/3/1982 | 0 | 53.49 | 14.38 | 22.27 | 8.48 |  | 7 | Summer |  |  |  |  |  |  |  |  | 1999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999
20/3/1982 | 0 | 52.14 | 14.82 | 20.25 | 9.28 |  | 8 | Summer |  |  |  |  |  |  |  |  | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000
21/3/1982 | 0 | 43.93 | 17.7 | 25.94 | 11.33 |  | 9 | Autumn |  |  |  |  |  |  |  |  | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001
22/3/1982 | 0 | 44.67 | 18.11 | 26.62 | 8.98 |  | 10 | Autumn |  |  |  |  |  |  |  |  | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002
23/3/1982 | 0 | 52.59 | 18.87 | 25.33 | 12.53 |  | 11 | Autumn |  |  |  |  |  |  |  |  | 2003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003
24/3/1982 | 0.01 | 50.95 | 15.69 | 22.33 | 10.25 |  | 12 | Winter |  |  |  |  |  |  |  |  | 2004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2004
25/3/1982 | 0.09 | 61.73 | 14.99 | 20.65 | 10.52 |  |  |  |  |  |  |  |  |  |  |  | 2005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2005
26/3/1982 | 0.01 | 51.62 | 13.94 | 20.03 | 9.05 |  |  |  |  |  |  |  |  |  |  |  | 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2006
27/3/1982 | 0.49 | 50 | 13.79 | 18.66 | 9.6 |  |  |  |  |  |  |  |  |  |  |  | 2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2007
28/3/1982 | 0 | 46.5 | 14.1 | 20.85 | 9.04 |  |  |  |  |  |  |  |  |  |  |  | 2008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008
29/3/1982 | 0 | 47.09 | 14.48 | 21.95 | 9.01 |  |  |  |  |  |  |  |  |  |  |  | 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009
30/3/1982 | 0 | 45.75 | 15.72 | 25.17 | 6.7 |  |  |  |  |  |  |  |  |  |  |  | 2010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010
31/3/1982 | 0.01 | 37.71 | 18.94 | 28.4 | 9.17 |  |  |  |  |  |  |  |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011
1/4/1982 | 0 | 25.81 | 18.85 | 24.64 | 13.42 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012
2/4/1982 | 0 | 21.53 | 22.17 | 32.65 | 14.04 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013
3/4/1982 | 0 | 34.12 | 22.55 | 32.56 | 16.6 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014
4/4/1982 | 0 | 61.77 | 18.35 | 24.36 | 13.77 |  |  |  |  |  |  |  |  |  |  |  | 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015
5/4/1982 | 0 | 60.8 | 17.38 | 24.26 | 12.41 |  |  |  |  |  |  |  |  |  |  |  | 2016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016
6/4/1982 | 0 | 59.21 | 17.38 | 25.02 | 11.31 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017
7/4/1982 | 0 | 49.76 | 16.79 | 23.7 | 10.23 |  |  |  |  |  |  |  |  |  |  |  | 2018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018
8/4/1982 | 0 | 44.95 | 17.71 | 24.69 | 10.36 |  |  |  |  |  |  |  |  |  |  |  | 2019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
9/4/1982 | 0 | 40.51 | 20.76 | 28.26 | 14.76 |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020
10/4/1982 | 0 | 52.51 | 20.25 | 28.9 | 13.91 |  |  |  |  |  |  |  |  |  |  |  | 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
11/4/1982 | 0 | 61.65 | 19 | 27.2 | 13.06
12/4/1982 | 0 | 54.35 | 19.31 | 28.13 | 12.32
13/4/1982 | 0 | 51.81 | 19.31 | 28.58 | 11.93
14/4/1982 | 0 | 44.21 | 19.25 | 28.66 | 11.63
15/4/1982 | 0 | 44.55 | 21.74 | 31.08 | 13.03
16/4/1982 | 0 | 38.54 | 24.45 | 33.79 | 16.23
17/4/1982 | 0.05 | 38.1 | 23.91 | 34.35 | 17.74
18/4/1982 | 0 | 47.77 | 21.71 | 29.87 | 14.53
19/4/1982 | 0 | 40.65 | 22.22 | 30.6 | 14.58
20/4/1982 | 0.07 | 35.53 | 24.6 | 33.62 | 16.81
21/4/1982 | 0 | 39.73 | 23.04 | 32.7 | 16.96
22/4/1982 | 0 | 49.24 | 20.94 | 28.55 | 15.16
23/4/1982 | 0 | 49.52 | 19.6 | 26.23 | 14.06
24/4/1982 | 0 | 42.65 | 21.49 | 29.95 | 14.36
25/4/1982 | 0 | 56.57 | 21.4 | 28.44 | 16.79
26/4/1982 | 0 | 53.06 | 18.9 | 23.67 | 14.01
27/4/1982 | 0 | 50.77 | 17.07 | 23.45 | 12.02
28/4/1982 | 0 | 29.55 | 22.41 | 31.42 | 11.5
29/4/1982 | 1.8 | 47.52 | 22.19 | 28.65 | 16.26
30/4/1982 | 3.87 | 64.34 | 19.96 | 26.44 | 14.63
1/5/1982 | 0.06 | 60.55 | 19.67 | 24.63 | 14.23
2/5/1982 | 0.42 | 45.86 | 18.51 | 25.4 | 11.66
3/5/1982 | 0 | 46.4 | 19.92 | 27.98 | 12.1
4/5/1982 | 0 | 47.13 | 20.39 | 28.56 | 12.52
5/5/1982 | 0.06 | 55.21 | 19.65 | 25.69 | 14.9
6/5/1982 | 0 | 55.3 | 19.84 | 27.16 | 13.23
7/5/1982 | 0.11 | 47.94 | 20.14 | 27.87 | 13.19
8/5/1982 | 0 | 47.36 | 20.24 | 29.35 | 12.14
9/5/1982 | 0.17 | 51.01 | 22.12 | 31 | 14.06
10/5/1982 | 0.04 | 49.47 | 23.24 | 32.21 | 15.15
11/5/1982 | 0.01 | 51.03 | 24.32 | 33.01 | 16.51
12/5/1982 | 0 | 53.66 | 24.83 | 31.99 | 18.76
13/5/1982 | 0.05 | 54.15 | 24.66 | 31.83 | 18.33
14/5/1982 | 0 | 47.47 | 25.13 | 34.31 | 17.12
15/5/1982 | 0 | 36.95 | 27.05 | 35.39 | 18.11
16/5/1982 | 0 | 45.12 | 25.05 | 31.44 | 19.02
17/5/1982 | 0 | 57.06 | 20.81 | 26.69 | 16.67
18/5/1982 | 0 | 54.87 | 20.41 | 26.36 | 16.15
19/5/1982 | 0 | 55.03 | 20 | 26.91 | 13.9
20/5/1982 | 0 | 52.94 | 20.84 | 28.02 | 13.76
21/5/1982 | 0 | 47.72 | 22.67 | 31.23 | 14.81
22/5/1982 | 0 | 53.7 | 22.25 | 29.43 | 16.46
23/5/1982 | 0 | 50.69 | 22.33 | 29.58 | 15.17
24/5/1982 | 0.16 | 54.45 | 21.53 | 28.49 | 16.11
25/5/1982 | 0 | 51.78 | 22.26 | 29.45 | 16.33
26/5/1982 | 0 | 44.16 | 22.67 | 31 | 15.27
27/5/1982 | 0 | 38.86 | 24.36 | 33.05 | 14.82
28/5/1982 | 0 | 40.75 | 24.92 | 34.25 | 17.57
29/5/1982 | 0 | 47.85 | 23.14 | 30.49 | 16.92
30/5/1982 | 0 | 47.52 | 22.93 | 29.96 | 17.63
31/5/1982 | 0 | 52.82 | 22.56 | 28.5 | 17.19
1/3/1983 | 0 | 48.15 | 12.5 | 21.82 | 5.07
2/3/1983 | 0 | 59.75 | 14.59 | 21.63 | 7.74
3/3/1983 | 0 | 41.66 | 15.37 | 23.81 | 9.27
4/3/1983 | 1.86 | 60.42 | 13.22 | 16.28 | 10.81
5/3/1983 | 1.85 | 55.04 | 10.38 | 12.64 | 8.76
6/3/1983 | 0.15 | 51.73 | 10.84 | 15.08 | 8
7/3/1983 | 0 | 62.11 | 11.12 | 16.82 | 6.83
8/3/1983 | 0 | 62.92 | 12.15 | 17.65 | 8.67
9/3/1983 | 0 | 65.66 | 13.67 | 20.64 | 8.46
10/3/1983 | 0 | 65.28 | 13.77 | 21.43 | 8.24
11/3/1983 | 0 | 66.54 | 13.02 | 19.89 | 8.16
12/3/1983 | 0 | 62.24 | 13.99 | 21.32 | 8.74
13/3/1983 | 0 | 56.86 | 14.64 | 23.15 | 7.74
14/3/1983 | 0.95 | 61.64 | 12.45 | 16.77 | 8.43
15/3/1983 | 2.53 | 64.5 | 11.14 | 14.63 | 8.48
16/3/1983 | 0.49 | 66.11 | 12.87 | 18.01 | 9.27
17/3/1983 | 0 | 58.83 | 13.96 | 21.44 | 7.45
18/3/1983 | 0 | 51.48 | 14.97 | 24.12 | 7.01
19/3/1983 | 0 | 44.19 | 16.8 | 26.92 | 8.95
20/3/1983 | 0 | 56.73 | 14.38 | 20.89 | 9.09
21/3/1983 | 0.06 | 68.43 | 13.44 | 19.1 | 8.67
22/3/1983 | 0.47 | 62.52 | 14.03 | 20.8 | 9.15
23/3/1983 | 0 | 53.1 | 14.83 | 23.03 | 7.11
24/3/1983 | 0 | 46.97 | 16.31 | 26 | 7.28
25/3/1983 | 0 | 48.39 | 16.69 | 26.42 | 8.99
26/3/1983 | 0.08 | 49.52 | 18.37 | 28.63 | 8.44
27/3/1983 | 0 | 41.78 | 18.38 | 27.89 | 11.25
28/3/1983 | 0 | 62.36 | 15.61 | 23.62 | 9.79
29/3/1983 | 0 | 60.32 | 16.22 | 24.28 | 10.48
30/3/1983 | 0 | 54.15 | 17.46 | 27.28 | 9.01
31/3/1983 | 0 | 53.19 | 18.78 | 25.76 | 12.27
1/4/1983 | 0 | 43.63 | 20.07 | 27.5 | 13.62
2/4/1983 | 0 | 62.83 | 17.03 | 24.31 | 11.52
3/4/1983 | 0 | 61.53 | 16.02 | 23.74 | 10.58
4/4/1983 | 0 | 50.96 | 17.44 | 26.82 | 10.54
5/4/1983 | 0 | 38.31 | 19.54 | 29.4 | 9.33
6/4/1983 | 0 | 39.2 | 20.09 | 30.28 | 14.1
7/4/1983 | 0 | 54.95 | 16.15 | 22.16 | 11.11
8/4/1983 | 0 | 56.1 | 16.37 | 24.46 | 9.58
9/4/1983 | 0 | 64.08 | 16 | 23.1 | 10.31
10/4/1983 | 0 | 58.41 | 16.9 | 24.77 | 10.29
11/4/1983 | 0 | 59.22 | 17.32 | 25.28 | 10.19
12/4/1983 | 0 | 54.4 | 18.4 | 27.06 | 10.84
13/4/1983 | 0 | 42.83 | 19.72 | 28.95 | 11.39
14/4/1983 | 0 | 34.88 | 21.33 | 31.2 | 11.53
15/4/1983 | 0 | 40.36 | 21.19 | 30.46 | 14.26
16/4/1983 | 0 | 57.61 | 18.59 | 26.05 | 12.86
17/4/1983 | 0.12 | 54.51 | 15.22 | 20.15 | 11.12
18/4/1983 | 0.07 | 49.16 | 15.13 | 21.1 | 10.65
19/4/1983 | 0 | 44.2 | 16.13 | 23.5 | 10.51
20/4/1983 | 0 | 49.36 | 17.01 | 25.41 | 9.78
21/4/1983 | 0 | 55.37 | 18.36 | 27.45 | 11.19
22/4/1983 | 0 | 53.86 | 18.45 | 26.68 | 11.79
23/4/1983 | 0 | 50.86 | 18.14 | 24.33 | 11.56
24/4/1983 | 0 | 43.88 | 19.9 | 28.57 | 11.29
25/4/1983 | 0 | 40.86 | 20.89 | 29.96 | 12.16
26/4/1983 | 0 | 45.13 | 21.85 | 30.14 | 15.25
27/4/1983 | 0 | 48.08 | 21.72 | 30.28 | 13.89
28/4/1983 | 0 | 46.1 | 22.23 | 31.26 | 14.21
29/4/1983 | 0 | 45.01 | 22.31 | 31.87 | 13.58
30/4/1983 | 0 | 37.01 | 23.49 | 33.08 | 14.58
1/5/1983 | 0 | 38.67 | 23.24 | 31.88 | 15.49
2/5/1983 | 0 | 39.88 | 25.24 | 34.89 | 15.78
3/5/1983 | 0 | 37.27 | 26.07 | 35 | 20.41
4/5/1983 | 0 | 51.76 | 22.49 | 29.28 | 16.36
5/5/1983 | 0 | 47.72 | 21.01 | 29.02 | 14.05
6/5/1983 | 0 | 47.91 | 19.91 | 27.81 | 12.88
7/5/1983 | 0 | 48.11 | 20.74 | 28.53 | 13.6
8/5/1983 | 0 | 45.61 | 21.5 | 29.89 | 14.63
9/5/1983 | 0 | 35.47 | 23.22 | 32.86 | 13.78
10/5/1983 | 0 | 39.85 | 23.44 | 30.58 | 17.38
11/5/1983 | 0 | 38.08 | 25.23 | 34.45 | 17.53
12/5/1983 | 0.06 | 52.47 | 22.49 | 28.02 | 16.29
13/5/1983 | 0 | 55.04 | 23.58 | 31.92 | 17.73
14/5/1983 | 0 | 56.75 | 23.04 | 29.62 | 17.57
15/5/1983 | 0 | 51 | 23.1 | 30.78 | 16.3
16/5/1983 | 0 | 47.72 | 22.54 | 30.5 | 14.84
17/5/1983 | 0 | 49.75 | 23.61 | 31.98 | 16.46
18/5/1983 | 0 | 52.17 | 22.83 | 30.2 | 16.2
19/5/1983 | 0 | 51.47 | 22.96 | 29.89 | 16.17
20/5/1983 | 0 | 45.92 | 23.38 | 31.18 | 16.79
21/5/1983 | 0 | 56.43 | 23.11 | 30.07 | 17.22
22/5/1983 | 0 | 49.72 | 23.62 | 31.23 | 17
23/5/1983 | 0 | 43.36 | 24.75 | 32.65 | 16.7
24/5/1983 | 0 | 36.39 | 27.24 | 37.14 | 19.23
25/5/1983 | 0 | 46.99 | 25.07 | 33.22 | 18.85
26/5/1983 | 0 | 42.79 | 23.69 | 32.27 | 16.57
27/5/1983 | 0 | 42.78 | 23.6 | 32.01 | 15.95
28/5/1983 | 0 | 39.94 | 25.02 | 33.7 | 17.31
29/5/1983 | 0 | 36.14 | 26.83 | 36.49 | 17.99
30/5/1983 | 0 | 35.83 | 28.24 | 38.11 | 19.41
31/5/1983 | 0 | 48.94 | 26.6 | 34.78 | 20.97