Add Months & Years in Excel - 2 Minute Excel Formula

preview_player
Показать описание
How to add Months to date fields in Excel without worrying which month of the year.
This video will go through the DATE formula and how to add months to excel

The same idea will give you ideas on how to add YEARS to formula as well.

Learn how to add months in Excel.
Tutorial on how to add months in Excel

OTHER 2 Minute EXCEL Tutorials:

2 MINUTE EXCEL FORMULA TUTORIALS

Рекомендации по теме
Комментарии
Автор

Tried and tried and couldn't get it to work. Copied your work ver batin and no luck. What am I doing wrong?

steves
Автор

Is there a reason you'd not just use the EDATE function?

dbellconsulting
Автор

Hi, Please always share the excel sheet you used. many thanks

rabdu
Автор

how to add (for example ) 4 years, 1 months, 21 days to 1 years, 4 months, 0 days

viswakumarvg
Автор

This doesn't account for adding months that go to the next year.

normangolden