Time Stamp formula
fairly certain that there's a parantheses missing somewhere in that....
"vezerid" wrote:
On May 2, 6:11 pm, Murph wrote:
I am trying to place a time stamp in cell L2 if there is text inside of cells
F2:J2. This seems like it should be an easy thing to do but I can't wrap my
brain around it this morning.
The formula I have so far is simply:
=IF(F20,NOW(), )
This gives me a time stamp for only cell F2, but I need the formula to watch
from F2-J2. Thanks in advance.
=IF(OR(F2:J2<"",NOW(),"")
HTH
Kostis Vezerides
|