Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert an annual salary to monthly in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=A2/12✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Annual Salary | Monthly Gross |
| 60000 | |
| 85000 | |
| 120000 | |
| 45000 |
=A2/12→5000
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter annual salaries in column A.
- 2For monthly pay: =A2/12 in B2.
- 3For semi-monthly (24 pay periods): =A2/24.
- 4For bi-weekly (26 pay periods): =A2/26.
- 5Format the result column as Currency.
Tips
- For bi-weekly payroll, use 26 — not 24. Bi-weekly means every two weeks (26 times/year); semi-monthly means twice a month (24 times/year).
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I calculate the daily rate from annual salary?
Divide by working days: =A2/260 for a 5-day week with no holidays, or use =A2/NETWORKDAYS(DATE(YEAR(TODAY()),1,1),DATE(YEAR(TODAY()),12,31)) for the actual count.
How do I convert monthly to annual?
Simply multiply by 12: =A2*12.
More on Finance basics
See all →How-to
How to calculate compound interest
Calculate a compounded closing balance from principal, annual nominal rate, compounding frequency and years, then separate the interest earned.
How-toHow to calculate the effective annual interest rate
Convert a positive nominal annual rate and a whole-number compounding frequency into an effective annual rate with EFFECT.
How-toHow to calculate the break-even point in units
Divide fixed costs by unit contribution margin and round up to whole units, with an explicit message when the margin is nonpositive.
How-toHow to calculate tiered commission
Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.
How-toHow to calculate net pay
Calculate take-home (net) pay by subtracting every deduction from gross salary, with worked examples for fixed amounts, percentage tax, and slab-based tax. Excel and Google Sheets.
How-toHow to calculate gross margin
Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.