Populating a date field with todays date when data is entered in another cell

**tlister3** · 02-22-2008, 10:49 PM

OK, first post for me, be gentle. I am trying to automatically populate a cell with todays date when data is entered (or changed if that's possible) to an adjoining cell, and blank if the adjoining cell has no data. Just a list I want to track when a field is updated, without having to manually populate the date field beside the data, ie

A B C
Date updated
Salesperson 1 Neil 01/02/08
Salesperson 2 (blank)
Phone number 02 === 16/02/08
Fax number 02 === 16/02/08

I found the 'Creating formulas that only return results from non-blank cells which can get me part of the way, but no idea how I can get a 'todays date' return.

Anyone?

**tlister3** · 02-22-2008, 11:07 PM

Got it sussed guys thanks, formula is:

=IF(ISBLANK(B138)=FALSE,TODAY(),"")

if that helps anyone else.
Cheers
T

**mudraker** · 02-22-2008, 11:15 PM

today() will return the current date every time the sheet is recalculated

E.G Excel calculates the sheet today your today() formula will show todays date.
Tomorrow Excel calculates your sheet the date shown by today() will be changed to tommorows date.

Theses 2 links may help you

http://www.excelforum.com/showthread.php?t=59735
http://www.excel-it.com/Forum/viewtopic.php?t=387