Thread: Automatically insert date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sheryar khan sheryar khan is offline
external usenet poster
  
Posts: 3
Default Automatically insert date
Hi!
I have column "A" for date. I want to do that if I enter data in
column "B" column, Column "A" automaticcaly insert today date. I have
the following function but when I open my worksheet next time it
automatically change that date to current date.

=IF(B6="","",TODAY())

Is this possible.
Reply With QuoteReply With Quote