date

A

amir

yes, but i have to type that code every time i open excel.What i really want
to know is there a way that, once i set the date it has to update
automaticaly and appear in a cell when i open excel.
 
D

David Biddulph

If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
 
A

amir

atlast....thanks

David Biddulph said:
If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting templates 7
outlook2003 question 1
Autofill Date in Word 15.33 for Mac 0
Display weeks from a Milestone 0
Icon doesn't make sense 0
How to automate update on weekly reports spreadsheet 0
Get the right language when inserting a date 2
Date and Time Picker 6.0 0

Top