View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Murph Murph is offline
external usenet poster
 
Posts: 37
Default Time Stamp formula

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.