when i typed in the formula, i got a date "38817"
That is the date serial number (the way Excel internally stores
dates, the number of days since 0-Jan-1900). Format the cell for
Date and all will be right in your world.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"sunderland27" wrote in
message
...
when i typed in the formula, i got a date "38817"
"Gary''s Student" wrote:
=IF(A1="no",TODAY(),"")
--
Gary''s Student
"sunderland27" wrote:
i want to be able to have the current date populate a field
when another
field is select "no". can anyone help?