ExcelBanter - how to insert the date in and make it change automatiquely

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to insert the date in and make it change automatiquely (https://www.excelbanter.com/excel-programming/377654-how-insert-date-make-change-automatiquely.html)

cpl

how to insert the date in and make it change automatiquely

Gord Dibben

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:

[email protected]

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:

Gord Dibben

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:

All times are GMT +1. The time now is 11:25 PM.