| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make date change in excel to current date when opening daily?
Can someone please tell me how to set a default in excel to make the date
current evey time i open a file. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make date change in excel to current date when opening daily?
=TODAY() typed in any cell will return the current date. If the file is
saved and re-opened tomorrow, it will show tomorrow's date....... hth Vaya con Dios, Chuck, CABGx3 "jamie" wrote: Can someone please tell me how to set a default in excel to make the date current evey time i open a file. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make date change in excel to current date when opening daily?
=TODAY( )
"jamie" wrote: Can someone please tell me how to set a default in excel to make the date current evey time i open a file. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make date change in excel to current date when opening daily?
"jamie" wrote:
Can someone please tell me how to set a default in excel to make the date current evey time i open a file. Use the TODAY() function Eg: in A1: =TODAY() A1 will always return the current date (calc mode assumed set to auto, of course) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| how do I change date format in the header in Excel XP ? | Excel Discussion (Misc queries) | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Excel 2003 Inserting current date | Excel Discussion (Misc queries) | |||
Hybrid Mode
