Adding Years, Months, and Days to Date in Excel

Thanks! Share it with your friends!

Close

Suppose you want to adjust a project’s schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks. And you might be thinking now how you can do this as simple as possible….

…. and sometimes Excel Date’s seem a but of a mystery ….

The DATE function is the solution. There are a lot of cool functions for dealing with dates in Excel. But this video shows you how to add Years, Months or Days in a date by using this simple formula.

I think the DATE function is the most versatile function in excel. Watch this short video and you’ll surely love it – together with DAY(), MONTH() and YEAR()

Comments

Write a comment

*

 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.