Excel date function

  • Thread starter Thread starter Sheela
  • Start date Start date
S

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
 
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
 
Sheela said:
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
Click to expand...

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).
 
Back
Top