| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A formula or macro that will place the date in an adjacent column Bany time something is typed in column A
Hello - I am trying to create a formula or macro that simply places
the date in a column each time that I type in an adjacent column. I tried using =IF(A3="","",TODAY()), but it refreshes the today date each time I open the worksheet (thus not leaving the prior date in the cell. Any ideas? Thanks for any suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Place Date in One column when entry is made in another column. | Excel Worksheet Functions | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| How do place a column of date/time information into a calendar for | Excel Discussion (Misc queries) | |||
![Mike C[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
