| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date updated conditionally based upon other cells
Could someone help me with this?
I want dates in column A to update automatically when a value is entered or changed in any of a series of cells For example: A1 is 1/16/06 and cells G1 through P1 are empty then on 1/17/06 I enter data in cell L1 so I want that to cause cell A! to now reflect this updated date. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date updated conditionally based upon other cells
Take a look at
http://www.mcgimpsey.com/excel/timestamp.html In article , RachRB wrote: Could someone help me with this? I want dates in column A to update automatically when a value is entered or changed in any of a series of cells For example: A1 is 1/16/06 and cells G1 through P1 are empty then on 1/17/06 I enter data in cell L1 so I want that to cause cell A! to now reflect this updated date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on a date + 30 days | Excel Discussion (Misc queries) | |||
| how do i add in numbers automatically based on adjacent cells cont | Excel Discussion (Misc queries) | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
| Count cells based on date range in another column | New Users to Excel | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
Linear Mode
