|
Featured Tutorial
Featured Macro
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
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