View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Time Stamp formula

Regardless it will not give a time stamp when something was entered if
that's what you want, it will change with the computer's clock so when you
open it tomorrow it will have the date of tomorrow

http://www.mcgimpsey.com/excel/timestamp.html

has examples of real time stamps



--
Regards,

Peo Sjoblom


"Murph" wrote in message
...
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.