Convert year-month intervals to months
Turn an interval like +02-03 into 27 calendar months, not days.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | IF(LEFT(A8,1)="-",-1,1) | Gives -1 if the interval starts with a minus, else 1. | 1 |
| 2 | VALUE(MID(A8,2,LEN(A8)-4))*12 | Reads the years after the sign and turns them into months. | 24 |
| 3 | VALUE(RIGHT(A8,2)) | Adds the last 2 digits as months. | 27 |
Part 1 sets the sign. Parts 2 and 3 add up the months, then the sign is applied to the total.
=IF(LEFT(A8,1)="-",-1,1)*(VALUE(MID(A8,2,LEN(A8)-4))*12+VALUE(RIGHT(A8,2)))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own intervals. Paste intervals like +02-03 into the green column of the Template tab. The totals fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
These are calendar months, not days. To get an end date, add them to a start date with EDATE.
Microsoft's help: VALUE function
OTHER ROUTES YOU MIGHT LIKE

Read timestamps wrapped in {ts}
{ts '2026-11-04 14:30:15'} → November 4, 2026 2:30:15 PM
Get the template →
Read /Date(…)/ values with a time zone
/Date(1793802615000+0100)/ → November 4, 2026 2:30:15 PM
Get the template →
Read GMT-0500 timestamps as UTC
Wed Nov 04 2026 14:30:15 GMT-0500 (EST) → 11/4/2026 19:30:15
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →