Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Date
I am trying to figure out a simple formula that when a user inserts
his initials into a cell the cell next to it gets the date corresponding to the day he filled out his initials. This is what I have =IF(ISBLANK(D6),"",Date) Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Date
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "newguy" wrote in message ... I am trying to figure out a simple formula that when a user inserts his initials into a cell the cell next to it gets the date corresponding to the day he filled out his initials. This is what I have =IF(ISBLANK(D6),"",Date) Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Date
=IF(ISBLANK(D6),"",TODAY())
and format as date On 13 Sty, 13:54, newguy wrote: I am trying to figure out a simple formula that when a user inserts his initials into a cell the cell next to it gets the date corresponding to the day he filled out his initials. This is what I have =IF(ISBLANK(D6),"",Date) Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Date
There is no simple worksheet function/formula that will do this and keep the
date/time static. You need event code. Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'when entering data in a cell in Col A On Error GoTo enditall Application.EnableEvents = False If Target.Cells.Column = 1 Then If Target.Value < "" Then Target.Offset(0, 1).Value = Now End If End If enditall: Application.EnableEvents = True End Sub Right-click on the sheet tab and "View Code". Copy/paste the code into that sheet module. Alt + q to return to the Excel window. Enter something in any cell in column A to get a static date/time entered in column B Gord Dibben MS Excel MVP On Tue, 13 Jan 2009 04:54:46 -0800 (PST), newguy wrote: I am trying to figure out a simple formula that when a user inserts his initials into a cell the cell next to it gets the date corresponding to the day he filled out his initials. This is what I have =IF(ISBLANK(D6),"",Date) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Insert new date once. | Excel Worksheet Functions | |||
Insert Hebrew Date | Excel Worksheet Functions | |||
Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions |