View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Display Current Date & Time in a cell: Everytime I open the workbo

hi
in any cell you wish, enter........
=now()

the cell will update each time the workbook is opened or the sheet is
calculated.
formula is volital meaning it don't stay the same for long.
if you just want the date without time..
=today()

regards
FSt1


regards
FSt1




"sam" wrote:

Hi All,

Is there a way I can display Current Date & Time in a cell which updates
everytime I open the workbook?

Thanks in Advance