auto date into a cell

[bamaisgreat]

Is there away for lets say. If A2 contains data then TODAYS date is entered into P4. Thanks as always....

 

[NARAYANK991]

Hi ,

The formula =IF(ISBLANK(A2),"",TODAY()) should do the job.

Narayan

 

[T. Valko]

Is there away for lets say. If A2 contains data then TODAYS date is entered into P4. Thanks as always....

Maybe this...

http://www.mcgimpsey.com/excel/timestamp.html

 

[bamaisgreat]

THANKS!!! That worked great

 

[bamaisgreat]

T.VALKO what do you enter if you want the date and time... thanks again

 

[MikeJK]

I have quite similar problem, but a little more complicated.

So, I have "A" column as an adding date (DD.MM.), but I want it to be automated without changing anymore..
I want the timestamp to appear to "A" when an item name is added to "B" column, the same row of course.
I want also, that the old timestamp won't change to current date even if "B" value is changed..

A second request, if easily done (not so important) is to be able to manually change the date, without taking away the formula from the cell..

Thanks in advance!

-Mike

 

[T. Valko]

T.VALKO what do you enter if you want the date and time... thanks again

Which technique are you using?

 

[bamaisgreat]

which technique are you using?

=if(isblank(a2),"",today())

 

[T. Valko]

=if(isblank(a2),"",today())

Try it like this...

=IF(A2="","",NOW())

Format in the date/time format of your choice.

Note that that formula result will change every time a calculation takes place. Is that what you want or do you want the date/time stamp to be static once data is entered? If so, then you won't be able to use that formula.

 

[bamaisgreat]

yes that one is good.Thanks
Do you know the correct format for a cell that will let you enter a @ without it seeing it as a email. Example: this is a steel size, 3@5. I have tried General and Text and it still turns it blue as it were email..