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
|
Important Date Functions (TODAY, NOW, YEAR, MONTH, DAY, DATE )
1. Important Date Functions (TODAY, NOW, YEAR, MONTH, DAY, DATE )