| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to insert the date in and make it change automatiquely
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to insert the date in and make it change automatiquely
Enter =TODAY() in a cell.
Will update with each passing day. Gord Dibben MS Excel MVP On Fri, 17 Nov 2006 14:33:02 -0800, cpl wrote: |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to insert the date in and make it change automatiquely
Wouldn't the formula be =NOW() ?
Gord Dibben wrote: Enter =TODAY() in a cell. Will update with each passing day. Gord Dibben MS Excel MVP On Fri, 17 Nov 2006 14:33:02 -0800, cpl wrote: |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to insert the date in and make it change automatiquely
OP asked for the date to change.
=TODAY() fulfills that request. If OP also wants the time and date he could use the =NOW() function. Gord Dibben MS Excel MVP On 17 Nov 2006 15:35:56 -0800, wrote: Wouldn't the formula be =NOW() ? Gord Dibben wrote: Enter =TODAY() in a cell. Will update with each passing day. Gord Dibben MS Excel MVP On Fri, 17 Nov 2006 14:33:02 -0800, cpl wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
| Condit Format? Make date change colors | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Linear Mode
