MONTH
Date & TimebeginnerMONTH returns the month as a number from 1 (January) to 12 (December). Essential for monthly grouping, seasonal analysis, and building month-over-month comparisons. Often combined with SUMIFS or COUNTIFS for monthly aggregation.
Syntax
Excel:
=MONTH(serial_number)Google Sheets: Same syntax
Parameters
serial_numberA date value or cell containing a date.? = optional parameter
Worked Example
What month was invoice INV-1005 issued?
| Row numbers | A | D | |
|---|---|---|---|
| Header row | invoice_id | invoice_date | =MONTH(date) |
| 2 | INV-1004 | 2025-02-03 | 2 |
| 3 | INV-1005 | 2025-02-08 | 2 |
| 4 | INV-1008 | 2025-03-05 | 3 |
Formula
=MONTH(B3)Result
2MONTH extracts the month number from B3, which is the invoice date for INV-1005. Because B3 contains 2025-02-08, the formula returns 2 for February.
Practice Exercises
2 exercises - work through each one using the data table below
Exercise 1 of 2beginner
#MONTH-001Question
How many invoices were issued in March (month 3)? Use MONTH with COUNTIF or SUMPRODUCT.
Dataset
Vendor Spend Tracker (150 rows total)
Download CSV| Row numbers | A | B | C |
|---|---|---|---|
| Header row | |||
| 2 | INV-1001 | 2025-01-15 | $12,500.00 |
| 3 | INV-1002 | 2025-01-18 | $487.50 |
| 4 | INV-1003 | 2025-01-22 | $18,750.00 |
| 5 | INV-1004 | 2025-02-03 | $3,200.00 |
| 6 | INV-1005 | 2025-02-08 | $7,600.00 |
| 7 | INV-1006 | 2025-02-14 | $9,800.00 |
| 8 | INV-1007 | 2025-02-19 | $2,150.00 |
| 9 | INV-1008 | 2025-03-05 | $15,300.00 |
| 10 | INV-1009 | 2025-03-10 | $4,250.00 |
| 11 | INV-1010 | 2025-03-15 | $8,900.00 |
| 12 | INV-1011 | 2025-01-04 | $8,500.00 |
| 13 | INV-1012 | 2025-01-09 | $8,256.80 |
| 14 | INV-1013 | 2025-01-10 | $713.88 |
| 15 | INV-1014 | 2025-01-16 | $2,645.33 |
| 16 | INV-1015 | 2025-01-17 | $4,702.01 |
| 17 | INV-1016 | 2025-01-21 | $3,400.74 |
| 18 | INV-1017 | 2025-02-09 | $531.83 |
| 19 | INV-1018 | 2025-02-18 | $1,847.86 |
| 20 | INV-1019 | 2025-02-19 | $7,800.00 |
| 21 | INV-1020 | 2025-02-22 | $2,524.82 |
| 22 | INV-1021 | 2025-02-25 | $2,934.55 |
| 23 | INV-1022 | 2025-03-02 | $2,912.75 |
| 24 | INV-1023 | 2025-03-04 | $4,124.04 |
| 25 | INV-1024 | 2025-03-10 | $672.77 |
| 26 | INV-1025 | 2025-03-12 | $5,371.63 |
| 27 | INV-1026 | 2025-03-13 | $3,796.96 |
| 28 | INV-1027 | 2025-03-14 | $1,773.30 |
| 29 | INV-1028 | 2025-03-14 | $4,601.68 |
| 30 | INV-1029 | 2025-03-15 | $5,414.85 |
| 31 | INV-1030 | 2025-03-17 | $2,704.87 |
| 32 | INV-1031 | 2025-03-19 | $2,351.63 |
| 33 | INV-1032 | 2025-03-20 | $9,200.00 |
| 34 | INV-1033 | 2025-04-01 | $4,086.27 |
| 35 | INV-1034 | 2025-04-01 | $1,642.50 |
| 36 | INV-1035 | 2025-04-03 | $2,867.94 |
| 37 | INV-1036 | 2025-04-05 | $4,586.87 |
| 38 | INV-1037 | 2025-04-07 | $2,679.33 |
| 39 | INV-1038 | 2025-04-10 | $2,284.90 |
| 40 | INV-1039 | 2025-04-11 | $3,224.17 |
| 41 | INV-1040 | 2025-04-15 | $604.96 |
| 42 | INV-1041 | 2025-04-15 | $9,500.00 |
| 43 | INV-1042 | 2025-04-16 | $3,871.90 |
| 44 | INV-1043 | 2025-04-17 | $5,726.55 |
| 45 | INV-1044 | 2025-04-20 | $3,596.33 |
| 46 | INV-1045 | 2025-04-22 | $5,657.73 |
| 47 | INV-1046 | 2025-04-23 | $8,000.00 |
| 48 | INV-1047 | 2025-04-24 | $396.69 |
| 49 | INV-1048 | 2025-05-01 | $523.99 |
| 50 | INV-1049 | 2025-05-03 | $5,843.41 |
| 51 | INV-1050 | 2025-05-06 | $5,091.38 |
| 52 | INV-1051 | 2025-05-15 | $6,200.00 |
| 53 | INV-1052 | 2025-05-17 | $10,496.53 |
| 54 | INV-1053 | 2025-05-18 | $3,873.77 |
| 55 | INV-1054 | 2025-05-18 | $2,131.07 |
| 56 | INV-1055 | 2025-05-21 | $4,659.43 |
| 57 | INV-1056 | 2025-05-24 | $7,500.00 |
| 58 | INV-1057 | 2025-06-01 | $3,255.52 |
| 59 | INV-1058 | 2025-06-06 | $2,889.22 |
| 60 | INV-1059 | 2025-06-07 | $2,943.88 |
| 61 | INV-1060 | 2025-06-10 | $3,917.25 |
| 62 | INV-1061 | 2025-06-10 | $2,958.71 |
| 63 | INV-1062 | 2025-06-12 | $5,190.48 |
| 64 | INV-1063 | 2025-06-13 | $3,800.00 |
| 65 | INV-1064 | 2025-06-13 | $3,248.96 |
| 66 | INV-1065 | 2025-06-15 | $6,800.00 |
| 67 | INV-1066 | 2025-06-16 | $4,583.65 |
| 68 | INV-1067 | 2025-06-17 | $4,154.73 |
| 69 | INV-1068 | 2025-06-23 | $1,994.85 |
| 70 | INV-1069 | 2025-06-25 | $5,988.79 |
| 71 | INV-1070 | 2025-07-01 | $701.90 |
| 72 | INV-1071 | 2025-07-06 | $1,522.67 |
| 73 | INV-1072 | 2025-07-07 | $8,100.00 |
| 74 | INV-1073 | 2025-07-08 | $33,000.00 |
| 75 | INV-1074 | 2025-07-08 | $3,618.53 |
| 76 | INV-1075 | 2025-07-08 | $5,484.82 |
| 77 | INV-1076 | 2025-07-09 | $2,190.73 |
| 78 | INV-1077 | 2025-07-11 | $4,915.98 |
| 79 | INV-1078 | 2025-07-11 | $5,337.06 |
| 80 | INV-1079 | 2025-07-13 | $5,217.40 |
| 81 | INV-1080 | 2025-07-15 | $4,199.01 |
| 82 | INV-1081 | 2025-07-16 | $7,880.94 |
| 83 | INV-1082 | 2025-07-17 | $738.04 |
| 84 | INV-1083 | 2025-07-18 | $9,500.00 |
| 85 | INV-1084 | 2025-07-19 | $3,706.27 |
| 86 | INV-1085 | 2025-07-21 | $3,934.09 |
| 87 | INV-1086 | 2025-07-23 | $2,463.38 |
| 88 | INV-1087 | 2025-08-04 | $404.67 |
| 89 | INV-1088 | 2025-08-04 | $1,909.04 |
| 90 | INV-1089 | 2025-08-05 | $2,885.01 |
| 91 | INV-1090 | 2025-08-05 | $5,922.08 |
| 92 | INV-1091 | 2025-08-05 | $3,693.48 |
| 93 | INV-1092 | 2025-08-07 | $4,986.06 |
| 94 | INV-1093 | 2025-08-08 | $31,500.00 |
| 95 | INV-1094 | 2025-08-09 | $4,248.05 |
| 96 | INV-1095 | 2025-08-12 | $3,264.04 |
| 97 | INV-1096 | 2025-08-13 | $5,977.55 |
| 98 | INV-1097 | 2025-08-13 | $3,214.26 |
| 99 | INV-1098 | 2025-08-15 | $8,200.00 |
| 100 | INV-1099 | 2025-08-15 | $2,709.54 |
| 101 | INV-1100 | 2025-08-16 | $3,516.17 |
| 102 | INV-1101 | 2025-08-17 | $3,122.47 |
| 103 | INV-1102 | 2025-08-17 | $4,530.21 |
| 104 | INV-1103 | 2025-08-17 | $4,352.17 |
| 105 | INV-1104 | 2025-08-18 | $3,137.30 |
| 106 | INV-1105 | 2025-08-22 | $4,559.89 |
| 107 | INV-1106 | 2025-08-24 | $7,400.00 |
| 108 | INV-1107 | 2025-08-24 | $2,724.75 |
| 109 | INV-1108 | 2025-09-04 | $3,957.64 |
| 110 | INV-1109 | 2025-09-08 | $2,398.15 |
| 111 | INV-1110 | 2025-09-08 | $5,015.14 |
| 112 | INV-1111 | 2025-09-13 | $30,500.00 |
| 113 | INV-1112 | 2025-09-16 | $3,646.25 |
| 114 | INV-1113 | 2025-09-17 | $5,200.86 |
| 115 | INV-1114 | 2025-09-18 | $1,878.57 |
| 116 | INV-1115 | 2025-09-19 | $4,287.78 |
| 117 | INV-1116 | 2025-09-19 | $5,505.30 |
| 118 | INV-1117 | 2025-09-19 | $4,658.66 |
| 119 | INV-1118 | 2025-09-20 | $5,042.80 |
| 120 | INV-1119 | 2025-09-21 | $7,000.00 |
| 121 | INV-1120 | 2025-09-21 | $3,893.42 |
| 122 | INV-1121 | 2025-09-21 | $5,864.21 |
| 123 | INV-1122 | 2025-09-24 | $3,920.27 |
| 124 | INV-1123 | 2025-09-25 | $4,600.00 |
| 125 | INV-1124 | 2025-09-25 | $1,602.74 |
| 126 | INV-1125 | 2025-09-25 | $5,250.09 |
| 127 | INV-1126 | 2025-09-25 | $4,417.14 |
| 128 | INV-1127 | 2025-10-03 | $5,900.00 |
| 129 | INV-1128 | 2025-10-04 | $4,618.54 |
| 130 | INV-1129 | 2025-10-05 | $8,800.00 |
| 131 | INV-1130 | 2025-10-05 | $4,003.25 |
| 132 | INV-1131 | 2025-10-06 | $11,892.88 |
| 133 | INV-1132 | 2025-10-10 | $2,800.34 |
| 134 | INV-1133 | 2025-10-11 | $4,365.68 |
| 135 | INV-1134 | 2025-10-12 | $2,264.09 |
| 136 | INV-1135 | 2025-10-21 | $5,344.04 |
| 137 | INV-1136 | 2025-10-24 | $1,733.29 |
| 138 | INV-1137 | 2025-10-25 | $2,251.07 |
| 139 | INV-1138 | 2025-11-07 | $367.30 |
| 140 | INV-1139 | 2025-11-13 | $3,235.55 |
| 141 | INV-1140 | 2025-11-20 | $4,538.25 |
| 142 | INV-1141 | 2025-11-21 | $7,200.00 |
| 143 | INV-1142 | 2025-11-24 | $2,487.53 |
| 144 | INV-1143 | 2025-12-09 | $4,398.73 |
| 145 | INV-1144 | 2025-12-15 | $4,282.05 |
| 146 | INV-1145 | 2025-12-16 | $300.36 |
| 147 | INV-1146 | 2025-12-18 | $9,000.00 |
| 148 | INV-1147 | 2025-12-19 | $4,697.90 |
| 149 | INV-1148 | 2025-12-19 | $2,613.37 |
| 150 | INV-1149 | 2025-12-20 | $4,097.38 |
| 151 | INV-1150 | 2025-12-23 | $1,846.11 |
| 152 |
Scroll to explore the table, then sort or filter by column as needed.
Hints
Your Answer
Exercise 2 of 2intermediate
#MONTH-002Question
Which month had the highest total spend? Give the month number (1-12).
Dataset
Vendor Spend Tracker (150 rows total)
Download CSV| Row numbers | A | B | C |
|---|---|---|---|
| Header row | |||
| 2 | INV-1001 | 2025-01-15 | $12,500.00 |
| 3 | INV-1002 | 2025-01-18 | $487.50 |
| 4 | INV-1003 | 2025-01-22 | $18,750.00 |
| 5 | INV-1004 | 2025-02-03 | $3,200.00 |
| 6 | INV-1005 | 2025-02-08 | $7,600.00 |
| 7 | INV-1006 | 2025-02-14 | $9,800.00 |
| 8 | INV-1007 | 2025-02-19 | $2,150.00 |
| 9 | INV-1008 | 2025-03-05 | $15,300.00 |
| 10 | INV-1009 | 2025-03-10 | $4,250.00 |
| 11 | INV-1010 | 2025-03-15 | $8,900.00 |
| 12 | INV-1011 | 2025-01-04 | $8,500.00 |
| 13 | INV-1012 | 2025-01-09 | $8,256.80 |
| 14 | INV-1013 | 2025-01-10 | $713.88 |
| 15 | INV-1014 | 2025-01-16 | $2,645.33 |
| 16 | INV-1015 | 2025-01-17 | $4,702.01 |
| 17 | INV-1016 | 2025-01-21 | $3,400.74 |
| 18 | INV-1017 | 2025-02-09 | $531.83 |
| 19 | INV-1018 | 2025-02-18 | $1,847.86 |
| 20 | INV-1019 | 2025-02-19 | $7,800.00 |
| 21 | INV-1020 | 2025-02-22 | $2,524.82 |
| 22 | INV-1021 | 2025-02-25 | $2,934.55 |
| 23 | INV-1022 | 2025-03-02 | $2,912.75 |
| 24 | INV-1023 | 2025-03-04 | $4,124.04 |
| 25 | INV-1024 | 2025-03-10 | $672.77 |
| 26 | INV-1025 | 2025-03-12 | $5,371.63 |
| 27 | INV-1026 | 2025-03-13 | $3,796.96 |
| 28 | INV-1027 | 2025-03-14 | $1,773.30 |
| 29 | INV-1028 | 2025-03-14 | $4,601.68 |
| 30 | INV-1029 | 2025-03-15 | $5,414.85 |
| 31 | INV-1030 | 2025-03-17 | $2,704.87 |
| 32 | INV-1031 | 2025-03-19 | $2,351.63 |
| 33 | INV-1032 | 2025-03-20 | $9,200.00 |
| 34 | INV-1033 | 2025-04-01 | $4,086.27 |
| 35 | INV-1034 | 2025-04-01 | $1,642.50 |
| 36 | INV-1035 | 2025-04-03 | $2,867.94 |
| 37 | INV-1036 | 2025-04-05 | $4,586.87 |
| 38 | INV-1037 | 2025-04-07 | $2,679.33 |
| 39 | INV-1038 | 2025-04-10 | $2,284.90 |
| 40 | INV-1039 | 2025-04-11 | $3,224.17 |
| 41 | INV-1040 | 2025-04-15 | $604.96 |
| 42 | INV-1041 | 2025-04-15 | $9,500.00 |
| 43 | INV-1042 | 2025-04-16 | $3,871.90 |
| 44 | INV-1043 | 2025-04-17 | $5,726.55 |
| 45 | INV-1044 | 2025-04-20 | $3,596.33 |
| 46 | INV-1045 | 2025-04-22 | $5,657.73 |
| 47 | INV-1046 | 2025-04-23 | $8,000.00 |
| 48 | INV-1047 | 2025-04-24 | $396.69 |
| 49 | INV-1048 | 2025-05-01 | $523.99 |
| 50 | INV-1049 | 2025-05-03 | $5,843.41 |
| 51 | INV-1050 | 2025-05-06 | $5,091.38 |
| 52 | INV-1051 | 2025-05-15 | $6,200.00 |
| 53 | INV-1052 | 2025-05-17 | $10,496.53 |
| 54 | INV-1053 | 2025-05-18 | $3,873.77 |
| 55 | INV-1054 | 2025-05-18 | $2,131.07 |
| 56 | INV-1055 | 2025-05-21 | $4,659.43 |
| 57 | INV-1056 | 2025-05-24 | $7,500.00 |
| 58 | INV-1057 | 2025-06-01 | $3,255.52 |
| 59 | INV-1058 | 2025-06-06 | $2,889.22 |
| 60 | INV-1059 | 2025-06-07 | $2,943.88 |
| 61 | INV-1060 | 2025-06-10 | $3,917.25 |
| 62 | INV-1061 | 2025-06-10 | $2,958.71 |
| 63 | INV-1062 | 2025-06-12 | $5,190.48 |
| 64 | INV-1063 | 2025-06-13 | $3,800.00 |
| 65 | INV-1064 | 2025-06-13 | $3,248.96 |
| 66 | INV-1065 | 2025-06-15 | $6,800.00 |
| 67 | INV-1066 | 2025-06-16 | $4,583.65 |
| 68 | INV-1067 | 2025-06-17 | $4,154.73 |
| 69 | INV-1068 | 2025-06-23 | $1,994.85 |
| 70 | INV-1069 | 2025-06-25 | $5,988.79 |
| 71 | INV-1070 | 2025-07-01 | $701.90 |
| 72 | INV-1071 | 2025-07-06 | $1,522.67 |
| 73 | INV-1072 | 2025-07-07 | $8,100.00 |
| 74 | INV-1073 | 2025-07-08 | $33,000.00 |
| 75 | INV-1074 | 2025-07-08 | $3,618.53 |
| 76 | INV-1075 | 2025-07-08 | $5,484.82 |
| 77 | INV-1076 | 2025-07-09 | $2,190.73 |
| 78 | INV-1077 | 2025-07-11 | $4,915.98 |
| 79 | INV-1078 | 2025-07-11 | $5,337.06 |
| 80 | INV-1079 | 2025-07-13 | $5,217.40 |
| 81 | INV-1080 | 2025-07-15 | $4,199.01 |
| 82 | INV-1081 | 2025-07-16 | $7,880.94 |
| 83 | INV-1082 | 2025-07-17 | $738.04 |
| 84 | INV-1083 | 2025-07-18 | $9,500.00 |
| 85 | INV-1084 | 2025-07-19 | $3,706.27 |
| 86 | INV-1085 | 2025-07-21 | $3,934.09 |
| 87 | INV-1086 | 2025-07-23 | $2,463.38 |
| 88 | INV-1087 | 2025-08-04 | $404.67 |
| 89 | INV-1088 | 2025-08-04 | $1,909.04 |
| 90 | INV-1089 | 2025-08-05 | $2,885.01 |
| 91 | INV-1090 | 2025-08-05 | $5,922.08 |
| 92 | INV-1091 | 2025-08-05 | $3,693.48 |
| 93 | INV-1092 | 2025-08-07 | $4,986.06 |
| 94 | INV-1093 | 2025-08-08 | $31,500.00 |
| 95 | INV-1094 | 2025-08-09 | $4,248.05 |
| 96 | INV-1095 | 2025-08-12 | $3,264.04 |
| 97 | INV-1096 | 2025-08-13 | $5,977.55 |
| 98 | INV-1097 | 2025-08-13 | $3,214.26 |
| 99 | INV-1098 | 2025-08-15 | $8,200.00 |
| 100 | INV-1099 | 2025-08-15 | $2,709.54 |
| 101 | INV-1100 | 2025-08-16 | $3,516.17 |
| 102 | INV-1101 | 2025-08-17 | $3,122.47 |
| 103 | INV-1102 | 2025-08-17 | $4,530.21 |
| 104 | INV-1103 | 2025-08-17 | $4,352.17 |
| 105 | INV-1104 | 2025-08-18 | $3,137.30 |
| 106 | INV-1105 | 2025-08-22 | $4,559.89 |
| 107 | INV-1106 | 2025-08-24 | $7,400.00 |
| 108 | INV-1107 | 2025-08-24 | $2,724.75 |
| 109 | INV-1108 | 2025-09-04 | $3,957.64 |
| 110 | INV-1109 | 2025-09-08 | $2,398.15 |
| 111 | INV-1110 | 2025-09-08 | $5,015.14 |
| 112 | INV-1111 | 2025-09-13 | $30,500.00 |
| 113 | INV-1112 | 2025-09-16 | $3,646.25 |
| 114 | INV-1113 | 2025-09-17 | $5,200.86 |
| 115 | INV-1114 | 2025-09-18 | $1,878.57 |
| 116 | INV-1115 | 2025-09-19 | $4,287.78 |
| 117 | INV-1116 | 2025-09-19 | $5,505.30 |
| 118 | INV-1117 | 2025-09-19 | $4,658.66 |
| 119 | INV-1118 | 2025-09-20 | $5,042.80 |
| 120 | INV-1119 | 2025-09-21 | $7,000.00 |
| 121 | INV-1120 | 2025-09-21 | $3,893.42 |
| 122 | INV-1121 | 2025-09-21 | $5,864.21 |
| 123 | INV-1122 | 2025-09-24 | $3,920.27 |
| 124 | INV-1123 | 2025-09-25 | $4,600.00 |
| 125 | INV-1124 | 2025-09-25 | $1,602.74 |
| 126 | INV-1125 | 2025-09-25 | $5,250.09 |
| 127 | INV-1126 | 2025-09-25 | $4,417.14 |
| 128 | INV-1127 | 2025-10-03 | $5,900.00 |
| 129 | INV-1128 | 2025-10-04 | $4,618.54 |
| 130 | INV-1129 | 2025-10-05 | $8,800.00 |
| 131 | INV-1130 | 2025-10-05 | $4,003.25 |
| 132 | INV-1131 | 2025-10-06 | $11,892.88 |
| 133 | INV-1132 | 2025-10-10 | $2,800.34 |
| 134 | INV-1133 | 2025-10-11 | $4,365.68 |
| 135 | INV-1134 | 2025-10-12 | $2,264.09 |
| 136 | INV-1135 | 2025-10-21 | $5,344.04 |
| 137 | INV-1136 | 2025-10-24 | $1,733.29 |
| 138 | INV-1137 | 2025-10-25 | $2,251.07 |
| 139 | INV-1138 | 2025-11-07 | $367.30 |
| 140 | INV-1139 | 2025-11-13 | $3,235.55 |
| 141 | INV-1140 | 2025-11-20 | $4,538.25 |
| 142 | INV-1141 | 2025-11-21 | $7,200.00 |
| 143 | INV-1142 | 2025-11-24 | $2,487.53 |
| 144 | INV-1143 | 2025-12-09 | $4,398.73 |
| 145 | INV-1144 | 2025-12-15 | $4,282.05 |
| 146 | INV-1145 | 2025-12-16 | $300.36 |
| 147 | INV-1146 | 2025-12-18 | $9,000.00 |
| 148 | INV-1147 | 2025-12-19 | $4,697.90 |
| 149 | INV-1148 | 2025-12-19 | $2,613.37 |
| 150 | INV-1149 | 2025-12-20 | $4,097.38 |
| 151 | INV-1150 | 2025-12-23 | $1,846.11 |
| 152 |
Scroll to explore the table, then sort or filter by column as needed.
Hints
Your Answer
Want more practice?
Test Me mode randomizes exercises across all formulas without telling you which formula to use.