hi ,

This is my first post..i need a help with updating a cell
Can Excel automatically update a cell with today's date when another cell is edited?
for instance if i update/change a value in A1 from 3000 to 300 can i some one help with a formula which can update the current date and time in B1 cell which was with yesterdays date and time..