Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Dates
If anything appears in cell A1, I would like the date to appear in cell B1.
However, once that date appears, I want that date to remain constant, not update daily. I need to know what date I sent a particular letter so the date must remain. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Dates
You may find what you need he
http://www.mcgimpsey.com/excel/timestamp.html The section using circular references shows that exact case. Hope this helps, Miguel. "JDay" wrote: If anything appears in cell A1, I would like the date to appear in cell B1. However, once that date appears, I want that date to remain constant, not update daily. I need to know what date I sent a particular letter so the date must remain. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Dates
Perhaps this will do as you wish.......
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range) If Not Range("a1").Value = "" Then Range("b1").Value = Date Else Range("b1").Value = "" End If End Sub Vaya con Dios, Chuck, CABGx3 "JDay" wrote: If anything appears in cell A1, I would like the date to appear in cell B1. However, once that date appears, I want that date to remain constant, not update daily. I need to know what date I sent a particular letter so the date must remain. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting dates | Excel Discussion (Misc queries) | |||
Inserting Dates | Excel Discussion (Misc queries) | |||
formula to add dates. | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |