TODAY Function (Functions in Excel)
Today Is | |
14-May-10 | =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 | 4881 | =TODAY()-C20 |
10-Aug-97 | 4660 | =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 | 4882 | =TODAY()-C28+1 |
10-Aug-97 | 4661 | =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 | -3786 | =C36-TODAY() |
0 comments:
Post a Comment