View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
anneleen machiels anneleen machiels is offline
external usenet poster
 
Posts: 1
Default display date of today in cell X when number 0 in cell Y

Hello, I am using excel 2007 and I am figuring out a way to display
the date of today (and 'capture' it) in one cell Y when there is a
number (0) entered in an other cell X.
The thing is that, when I open the excel sheet tomorrow, the date
displayed in Y still has to be the date of today and not have changed
in tomorrow's date.
Background : the purpose of the xls sheet is to create a sort of
logbook with entry's of file numbers and their entry/close dates.
....Sorry if this turns out to be a silly question : I'm just began to
learn Excel, so every help on my learning path is more than
appreciated.