Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hi all I have a small problem that I hope someone can help with. In cell A1 I have this code : =IF(B1=""," ",TODAY()) With this , if B4 is empty the cell is empty. If B4 has content then it puts the date. I replicate this down to A19. As I make entries in the cells in column B , so the date of entry is recorded. Unfortunately of course the date of entry is updated to the present date when I open the workbook. How can I fix the date of entry so that it remains at the date entry was originally made in column B? Grateful for any assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofill date on date entry in a separate column | Excel Worksheet Functions | |||
Fixing the date format in a macro or VBA | Excel Worksheet Functions | |||
Excel 2002 date entry: Cannot get away from d-m-yy entry format | Excel Discussion (Misc queries) | |||
Restricting date entry relative to current date | Excel Worksheet Functions | |||
Fixing the date. | New Users to Excel |