| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if/then insert date but don't want automatic updates
I have a spreadsheet tracking personnel actions. I tried the following
formula =IF(L2="","",TODAY()) but I do not want the date stamp to automatically update when the spreadsheet opens. How can I write a simple formula so that when the cell has text entered into it, the date will be recorded in the adjacent cell as a static stamp? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Automatic Date Insert | Excel Worksheet Functions | |||
| Automatic updates | Excel Discussion (Misc queries) | |||
| Sharing - Automatic Updates | Excel Discussion (Misc queries) | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| AUTOMATIC UPDATES | Excel Worksheet Functions | |||
Threaded Mode
