| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if data in one cell, then date in adjacent cell
column A is for date and column B is for data entry. I want column A to
populate with date when dat is entered into the adjacent cell in column B. Currently, in column A, I have: =if(b10,today(),""). The date does populate when I enter data in column B BUT every day I proceed down column B and enter data, the date changes in every cell in column A to the SAME DATE. How can I have the date stay at the date on whcih the data was entered? thanks! jane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying data to an adjacent cell | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Selecting data within a date range | Excel Worksheet Functions | |||
| Retrieving non adjacent data from other workbooks? | Excel Worksheet Functions | |||
| Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Threaded Mode
