Hello,

I'm trying to create a formula in a spreadsheet for the
date. This is to monitor the shares in the market.

How do I make the date field automatically appear on the
cell a value is entered in that row.

For example: if lets say tomorrow when I enter the
selling price in a column, the date should automatically
appear folowwing the system's current date.

I tried typing =today() in the date cell, the next day
when I auto fill the cell formula to next cell below, the
date above changes again to the current date.

Please help.

Thanks,
Sheela