Excel date function

[Sheela]

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

 

[Arvi Laanemets]

Hi

Principially no function can do it. It'll change the contents of worksheet,
and no function can change anything on worksheet by definition. The same for
formulas, as they are composed using functions and/or operators.
You have to write a VBA procedure or worksheets Change event for this. Or
you can use Ctrl+; key combination to enter today's date into cell.

Arvi Laanemets

 

[Paul]

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

You can enter today's date in a fixed form (i.e. that will not update
tomorrow) by using CTRL+; (hold down CTRL whilst pressing semicolon).