Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display current date

Status
Not open for further replies.
cousinconley

cousinconley

MIS
May 21, 2001
52
US
What is the formula to get excel to always display the current date in a cell?
 
Sort by date Sort by votes
Hi!

Try =Date()

hth
Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
I am not sure =DATE() would work, as it needs parameters.

Try =NOW() which gives you today's date and current time or

=TODAY() which just gives you today's date
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
374
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
185
ladyck3
ladyck3
Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
204
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365: [SOLVED ]Data Dump Date: "Jul 12 20:27:14 CDT 2022" convert to 07/12/2022 2
Replies
8
Views
137
ladyck3
ladyck3
XtL_D
  • Locked
  • Question
Weeknumber in Word 2010 for a date function (also for a merged date field from Excel)
Replies
14
Views
175
macropod
macropod

Part and Inventory Search

Sponsor

Back
Top