Excel Formula to Multiply a Value by Month
Question details
Create a formula that multiplies a value by a factor that decreases from 12 in January to 1 in December.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains a numeric value and a month name or date, and the multiplier should depend on the month.
- Observed behavior
- The desired result uses a multiplier of 12 for January, 11 for February, and so on, ending with 1 for December.
Place the numeric value in A1 and the month name or date in B1. Check whether B1 contains a full English month name as text or an actual Excel date, because each requires a different formula.
Multiply by month when the month is text
Use MATCH when B1 contains a full English month name, such as January or February.
Enter the number in A1 and a full English month name, such as January, in B1.
Select C1 and enter =(13-MATCH(B1,{"January","February","March","April","May","June","July","August","September","October","November","December"},0))*A1.
Press Enter. For example, if A1 is 10 and B1 is January, C1 returns 120.

Multiply by month when the cell contains a date
Use MONTH when B1 contains an actual Excel date rather than a month name stored as text.
Calculate month-based multipliers in WPS Spreadsheets
Use a MATCH formula in WPS Spreadsheets to multiply a value by a factor based on a month name, then save the workbook in Excel format.
- 1. Open a spreadsheet: Open WPS Spreadsheets and create a workbook or open an existing Excel file.
- 2. Enter the inputs: Type a numeric value in A1 and a full English month name in B1.
- 3. Add the formula: Select C1 and enter =(13-MATCH(B1,{"January","February","March","April","May","June","July","August","September","October","November","December"},0))*A1, then press Enter.
- 4. Save the workbook: Choose File > Save As and select XLSX if you want to share the workbook in Excel format.

Frequently Asked Questions
Why does the formula subtract the month number from 13?
January is month 1, so 13 minus 1 gives 12. December is month 12, so 13 minus 12 gives 1.
Can I use a date instead of a month name?
Yes. If B1 contains an actual date, enter =(13-MONTH(B1))*A1 in C1. The year and day do not change the multiplier.
Why does the MATCH formula return #N/A?
Check B1 for a full English month name that matches the list in the formula. Abbreviations, misspellings, and extra spaces can prevent a match.
How do I apply the formula to other rows?
After entering the formula in C1, drag the fill handle at the bottom-right corner of C1 down the column. The references will adjust to each row.




