# Is it possible have Date and Time remain after file chasnged or saved

#### pedro-egoli

##### Well-known Member
Interested to know if it is possible to use the Now Funtion in two columns , one for Date the other for time, and leave them unaltered when moving to cells before either saving and/or say reopening the next day.

This spreadsheet will show what happens now when I drag down from previous cells
Book1
ABCDEFG
1Datetime
224/03/200915:25thisshowedas24/3/200915:20whenIfirstdidit
Sheet1

Thanks again

Pedro

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
now will operate every time your workbook calculates. You can turn off calculation but that kind of defeats the purpose.

If you are looking for a time stamp - A Macro is a better option. You can then link it to a single cell change event - or even a key.

Thanks Makrini, I thought that might be the answer , am just trying to solve a situation where the date and time of an event are recorded forever, by an easy drag down method.

No good with writing macros .
Great weather down here suppose the same in Brisbane

Pedro

Not sure what you mean? But sounds like using "=now()" then copy paste special values and drag THAT down?

And yeah great weather here too - but I don't have a beach to enjoy it on!

Got to work on getting work from home access - and laptop it in from sunny places sipping ****tails...

Makrini,
In spreadsheet I just wanted to be able to highlight say cells A3 and B3 and use the little black box on right hand bottom of B3 to drag formula down.

Sounds like you have you are heading in the right direction so far as workplace is concerned.

Pedro

You can use "=Now()" and drag it down...

then copy paste special values over the top of the formula

There are other ways to do this BUT one way is ....
To use data Validation to keep your Dates / Time the same.
Just link the validation to a cell with the formula =Now()
and format your columns accordingly eg Date & Time format.
You then need to select the Date or time via the dropdown selector.

Thanks again Makrini, will try that later.

Thanks Ivan, your solution looks interesting except I am finding a problem with Validating Time

I selected Time /equal to/=Now() and custom formatted as " h:mm" .
When I dragged down it just dragged the previous time.
When I saved file it left Date the same , which it should today but I don't know how it will go tomorrow.
The Time remained the same as above.

Where am I going wrong?

Thanks
Pedro

Anybody able to help with this one please.

Pedro

Replies
2
Views
378
Replies
7
Views
298
Replies
2
Views
240
Replies
2
Views
429
Replies
1
Views
206

1,216,110
Messages
6,128,895
Members
449,477
Latest member
panjongshing

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back