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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying today's date (Excel 2000)

Status
Not open for further replies.
willhyde

willhyde

Technical User
Sep 3, 2001
29
0
0
GB
Hi,

is there a way of having a cell in Excel always display the current date, preferably in a dd/mm/yy format? Ideally this would refresh each time the workbook is loaded so it is always correct.

Cheers.
 
Sort by date Sort by votes
=today()

Set cell to desired display format via Format > Cells

Tired of waiting for an answer? Try asking better questions. See: faq222-2244
 
Upvote 0 Downvote
willhyde,

Use the TODAY() function
[tt]
=TODAY()
[/tt]
Format any way you prefer!

:)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Office 2000 XL
Replies
6
Views
344
dhookom
dhookom
Bijugate
  • Question
Excel update question
Replies
0
Views
105
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
133
combo
combo
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
220
SkipVought
S
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
153
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top