|
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()
|
|||
Monday, 16 September 2013
TODAY
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment