Excel has built in
two easy formulas that will automatically display the current date or current
date and time in your spreadsheet. Each
of these formulas will recalculate each time your spreadsheet is either reopened
or refreshed.
1. TODAY
-This
first option is to use the TODAY formula.
This formula will display the current date.
-To
use this formula, enter 'TODAY()' in the cell where you want the date displayed
-Press
Enter
-You
will now see the date
-Example
1:
-In
this example, I want to have the date auto populate in cell A2 each time the
report is opened
-In
cell A2 enter 'TODAY()'
-Press Enter
-The
date will now appear in cell A2
2. NOW
-The
second option is to use the NOW formula.
This formula will display the current date and time.
-To
use this formula, enter 'NOW()' in the cell where you want the date and time
displayed
-Press
Enter
-You
will now see the date and time
-Example
2:
-In
this example, I want to have the date and time auto populate in cell A2 each
time the report is opened
-In
cell A2 enter 'NOW()' and press Enter
-The
date and time will now appear in cell A2
Reminder: Each of
these formulas will recalculate each time the spreadsheet is reopened or the
sheet is recalculated.
Excel ya later!
No comments:
Post a Comment