View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default show date only if information entered in cell

Put this in A4:

=IF(C4="","",TODAY())

Format the cell as date.

Hope this helps.

Pete

On Oct 17, 2:26*pm, digitalmuse
wrote:
I want to have the current date show up in the first row say A whenever
someone enters information in a row - *in other words if there is data in
cell C4 then the current date should show up in row A4