### Excel Magic Trick # 281: Formula For Vest Date

See how to use the EDATE function in a formula to calculate the Vest Date for a contract. Also see the same formula with the DATE, YEAR, MONTH and DAY functions. The YEAR function looks at a date and tells you what year it is. Example YEAR(1/1/2005) is 2005 The MONTH function looks at a date and tells you what month it is. Example MONTH(1/1/2005) is 1 The DAY function looks at a date and tells you what day it is. Example DAY(1/1/2005) is 1 DATE function builds a date for you. Example: DATE(2004,2,2) is 2/2/2004 EDATE function gives you the same date, but a number of months in the future or past. Example EDATE(1/1/2004,2) is 3/1/2004 and EDATE(1/1/2004,-2) is 11/1/2003

Length:
02:09