Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Dates
If I enter anything in cell A1, I want the date automatically entered into
cell A2. How can I do this?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Dates
hi,
put this in a this workbook module Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Range("A1") = "" Then Exit Sub Else Range("A1").Offset(0, 1) = Date End If End Sub regards FSt1 "JDay" wrote: If I enter anything in cell A1, I want the date automatically entered into cell A2. How can I do this?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Dates
"JDay" wrote in message
... If I enter anything in cell A1, I want the date automatically entered into cell A2. How can I do this?? =IF(A1<"",TODAY(),""), and format as Date. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Intervals | Excel Worksheet Functions | |||
formula to add dates. | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |