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) |