auto date into a cell

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
794
Is there away for lets say. If A2 contains data then TODAYS date is entered into P4. Thanks as always....
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
794

ADVERTISEMENT

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

MikeJK

New Member
Joined
Feb 3, 2012
Messages
22
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

Well-known Member
Joined
May 9, 2009
Messages
16,623
=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

Well-known Member
Joined
Jan 23, 2012
Messages
794
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..
 

Watch MrExcel Video

Forum statistics

Threads
1,108,932
Messages
5,525,690
Members
409,660
Latest member
1817538628

This Week's Hot Topics

Top