TechnologyHow to Add Months to a Date in Microsoft...

How to Add Months to a Date in Microsoft Excel

-

- Advertisment -spot_imgspot_imgspot_imgspot_img

Microsoft Excel Logo.

Want to see what date it will be after you’ve a certain number of months have passed? Using Microsoft Excel’s EDATE function, you can add (or subtract) months to a specific date in your spreadsheets. Here’s how to use it.

RELATED: 13 Microsoft Excel Date and Time Functions You Should Know

How the EDATE Function Works

In Excel’s EDATE function, you specify the date (source date) to which you want to add months and the number of months to add. Excel then calculates the resulting date and displays it in your selected cell.

To subtract months from a date, enter a negative month number. For example, to remove 3 months from a date, enter -3 (minus three) instead of just 3 .

Add Months to a Date in Excel

To start the month addition process, open your spreadsheet with Microsoft Excel.

In your spreadsheet, select the cell in which you want to see the resulting date.

In your selected cell, type the following function and press Enter. In this function, replace C2 with the cell containing your source date and C4 with the cell having the number of months to add.

Tip: Just a reminder to use the “-” (minus) sign before the number of months if you want to subtract months from your date.

=EDATE(C2,C4)

Enter the EDATE function.

In your selected cell, you’ll see the date that occurs after adding your specified number of months.

The result of the EDATE function.

If you see a string of numbers instead of the resulting date, that means your cell isn’t using the date format. To fix that, in Excel’s ribbon at the top, click the “Home” tab. Then, in the “Number” section, click the drop-down menu and choose “Short Date.”

Choose the

You’re all set.

And that’s how you know what date it will be after you add a specific number of months to the source date. Very useful!


Did you know you can also add days instead of months to your dates? Check out our guide to learn how to do that.

RELATED: How to Add or Subtract Dates in Microsoft Excel

Read More

Latest news

The ultra high end brings new meaning to ‘exotic’

In the past, a brand that produced powertrains of awesome performance, or rarefied designs of outstanding touch and feel,...

Rolls-Royce readies for launch of first EV

Rolls-Royce Motor Cars built its legacy on throaty fossil fuel power, but it will be fully electric starting next...

Bentley changing its ways with EVs

Bentley will transition to an all-electric lineup by 2030, reveal its first full electric vehicle in 2025, and use...

Aston Martin pivots to electric amid turmoil

Wood. Leather. Timeless styling. Brutal performance. And a brand image admired the world over thanks to the James Bond...
- Advertisement -spot_imgspot_imgspot_imgspot_img
- Advertisement -spot_imgspot_imgspot_imgspot_img

Ford’s warning shows lingering supply woes

Ford Motor Co.'s warning last week that its third-quarter earnings will be marred by higher-than-expected supplier costs and a...

Netflix launches new studio in Finland

If you click on a link and make a purchase we...

Must read

The ultra high end brings new meaning to ‘exotic’

In the past, a brand that produced powertrains of...

Rolls-Royce readies for launch of first EV

Rolls-Royce Motor Cars built its legacy on throaty fossil...

Bentley changing its ways with EVs

Bentley will transition to an all-electric lineup by 2030,...

Aston Martin pivots to electric amid turmoil

Wood. Leather. Timeless styling. Brutal performance. And a brand...
- Advertisement -spot_imgspot_imgspot_img

You might also likeRELATED
Recommended to you