Important Date Functions (TODAY, NOW, YEAR, MONTH, DAY, DATE )

1. Important Date Functions (TODAY, NOW, YEAR, MONTH, DAY, DATE )


A
B
C
D
TODAY
Returns Current Date
=TODAY()
11/8/015
NOW
Returns Current Date
=NOW()
11/29/2015
17:43
MONTH
Returns numeric month from date
=MONTH (D4)
11
YEAR
Returns year in YYYY format
from date
=YEAR(D4)
2015
DAY
Returns numeric day from date
=DAY(D4)
29
DATE
=DATE(YEAR,MONTH,DAY)
=DATE(2015,4,1)
4/1/2015