View Single Post
  #1   Report Post  
Mike R.
 
Posts: n/a
Default TODAY() and stay that date..

Hello,
I am using a sheet in which people electronically sign. They type in their
name in A1 and then A2 has the formula =IF(A1="","",TODAY()). The sheet
could have many signatures and dates. The problem is that the date on all
signatures change to what the date is when the sheet is opened. Is there a
better formula to use? Thanks,
Mike