ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   date updated conditionally based upon other cells (https://www.excelbanter.com/excel-worksheet-functions/65410-date-updated-conditionally-based-upon-other-cells.html)

RachRB

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.


JE McGimpsey

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.



All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com