Insert Time and Date when a cell is no longer Blank

-emma-

Board Regular
Joined
Jul 14, 2006
Messages
180
Office Version
  1. 365
Platform
  1. Windows
Hi all,

Column A is made up from a Validation list. What I need is the following:
When A2 changes from blank to an entry from a dropdown option, B2 changes to the current time and date. I want this time and date to remain as it is and never change when the document is closed and reopened.

For example, as of right now I drop down the A2 entry to Emma, B2 would change from blank to 14:51 27/01/23 and always remain at that time and date. The same needs to happen the whole way down the document.

Just to add some news - this cannot be achieved by using VBA and or Macros as these are disabled for our work laptops.

Any help or steering in the right direct for this would be a massive help.

Thanks

Emma
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Kitap3.xlsx.xlsm
FG
611
62
63
6418:12 27.01.2023
03.02.23
Cell Formulas
RangeFormula
G64G64=IF(F61="","",IF(G66="",NOW(),G66))


I dont know if that works, please test it.
 
Upvote 0
Kitap3.xlsx.xlsm
FG
611
62
63
6418:12 27.01.2023
03.02.23
Cell Formulas
RangeFormula
G64G64=IF(F61="","",IF(G66="",NOW(),G66))


I dont know if that works, please test it.
Hi,
Thank you for your reply.
I modified your formula to the following:
=IF(F62="","",IF(F62=1,NOW(),0))

However, this changes the time when the document is closed and reopened.
 
Upvote 0
Hi,
Thank you for your reply.
I modified your formula to the following:
=IF(F62="","",IF(F62=1,NOW(),0))

However, this changes the time when the document is closed and reopened.
What about this?

VBA Code:
Sub selec()
 Range("A1").Select
 ActiveCell = Int(Now())
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top