Thread: Date and time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pietro Pietro is offline
external usenet poster
 
Posts: 62
Default Date and time

Hi all,

I need somebody to help me find the appropriate equation to do the
following:
When an employee selects his name from the drop down list in the cell
F1,today's date appears in A1 and time() in B2.
On the next day if an employee wants to change his name in the cell F1 and
selects another name,the date and time written in A1 and B2 DON'T change.
In other words,when users enter their names in F1 ,if A1 Is Null then
A1=today()
and if B1 Is Null then B1=NOW().