Monday, 16 September 2013

TODAY

Today Is
16-Sep-13
 =TODAY()
What Does It Do?




Use this to show the current date.
Syntax





 =TODAY()
Formatting




The result will normally be displayed using the DD-MMM-YY format.
Example





The following example shows how the Today function is used to calculate the number
of days since a particular day.
Date
Days Since
1-Jan-97
6102
 =TODAY()-C20
10-Aug-97
5881
 =TODAY()-C21
Note that the result is actually the number of days before todays date. To calculate
a result which includes the current date an extra 1 will need to be added.
Date
Days Since
1-Jan-97
6103
 =TODAY()-C28+1
10-Aug-97
5882
 =TODAY()-C29+1
Example





The following example shows the number of days from today until the year 2000.
Year 2000
Days Until
01-Jan-2000
-5007
 =C36-TODAY()


No comments:

Post a Comment