Thread: Automatically insert date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Automatically insert date
Take a look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

sheryar khan wrote:

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.

--

Dave Peterson
Reply With QuoteReply With Quote