TODAY ()
This
function shows the current system date. The result will be updated each time
the worksheet is opened and every day an entry is made anywhere on the
worksheet.
Best view in desktop mode.
|
A
|
B
|
|
|
1
|
Current Date
|
|
|
2
|
19-Feb-20
|
=TODAY()
|
|
3
|
2/19/2020
|
=TODAY()
|
|
4
|
February 19, 2020
|
=TODAY()
|
|
5
|
Syntax
=TODAY()
Formatting
The result will
normally be displayed using the DD-MMM-YY format like in cell A2.
Shortcut Key for Formatting
Go to A4 cell, Press
Ctrl+1, and you will see new pop-up window like below:
Example
The following
example shows how the Today function is used to calculate the number of days
since a particular day.
|
A
|
B
|
C
|
|
|
1
|
Date
|
Days Since
|
|
|
2
|
2-Oct-19
|
141
|
=TODAY()-A2
|
|
3
|
5-Jan-20
|
46
|
=TODAY()-A3
|
Note that
the result is actually the number of days before today’s date. To calculate a
result which includes the current date an extra 1 will need to be added.
|
A
|
B
|
C
|
D
|
|
|
1
|
Date
|
Days Since
|
||
|
2
|
1-Jan-19
|
416
|
=TODAY()-A2+1
|
|
|
3
|
10-Oct-19
|
134
|
=TODAY()-A3+1
|
|
The
following example shows the number of days from today until the year 2020.
|
A
|
B
|
C
|
D
|
|
|
1
|
Year 2020
|
Days Until
|
||
|
2
|
1-Jan-2020
|
-50
|
=A2-TODAY()
|
|
|
3
|
15-Aug-19
|
-189
|
=A2-TODAY()
|
|
No comments:
Post a Comment