automatically insert date in adjacent cell?

M

Mike B.

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!
 
D

Dave R.

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Adding cells until they are greater than a lookup cell and returning a value 1
Complex date VBA - insert a certain weekday 8
Word macro that can call cells out of Excel for a find and replace 0
Event recognition. 11
Adding A Date To Adjacent Cell 2
Merging from an Excel file with graphics 1
Excel does not accept text format! 0

Top