automatically insert date in adjacent cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i obviously know nothing about excel, but here we go. i want to have the current date entered into a cell if the left adjacent cell has a number value in it. this is what i have so far, but it's not working

=IF(ISNUMBER(RC[-1]), TODAY(), ""

any help would be great!
 
I think excel wants another cell reference, and RC[-1] wont do this. Just
put a formula like this one to the right of the cell you want to evaluate.


=IF(ISNUMBER(A1), TODAY(),"")



Mike B. said:
i obviously know nothing about excel, but here we go. i want to have the
Click to expand...
current date entered into a cell if the left adjacent cell has a number
value in it. this is what i have so far, but it's not working.
=IF(ISNUMBER(RC[-1]), TODAY(), "")

any help would be great!
Click to expand...
 
Back
Top