View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default Static current date based on when data in another column was enter

I want to setup a date column that each cell in the date column reflects the
date that another column in the same row was filled in.

Example: I enter a numerical value in cell D5 that is greater than 0. I want
A5 to record the date that I entered that data.

Also I would like to do the same thing with time in cell B5. How could I do
this?

Thanks a lot!