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()