Formula to Enter Today's Date if a Number is Added to a Column

[annacady]

How would I write a formula to enter Today's date in Column L when a number is placed in Column M? What I want is when I enter mileage in column M, Excel will automatically put today's date in column L. I do not want the date to change each day, just when I put a mileage in the first time.

 

[AnotherHiggins]

That cannot be done formulatically. The formula =TODAY() will give you today's date. But that formula is, by its very nature, dynamic - that is, it will change every day.

you could copy, paste special > values every day, but you don't want to do that.

Have a look at SkipVought's FAQ entitled, How to Add a DateStamp in Excel

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

'formulatically' should read 'formulaically'

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.