How to Auto fill the date when data is entered in another cell

**Shaunb2000** · 04-23-2013, 02:35 PM

Hello Excel Forum,
Basically like the title says.

I'm trying to get a cell to auto populate the date when entering data into another cell.

Please help.
Thanks in advanced,
Shaunb2000

**Lemice** · 04-23-2013, 02:37 PM

Hello,

Where is the date from? Basing on what criteria?
Can you provide a sample so it will be easier for others to help you also?

**Shaunb2000** · 04-23-2013, 02:45 PM

I would like for Cell (B2) to auto fill the current date when any type of data is entered in Cell (A1)

It could be any cell really, I could then make the necessary adjustment.
Hope that helps.

**Lemice** · 04-23-2013, 02:48 PM

If so, you can make use of a formula like this

Please Login or Register  to view this content.

and format it in Date.

**Shaunb2000** · 04-23-2013, 02:58 PM

AWESOME!!

That formula looks so simple, I feel like an idiot now. haha!

Thanks Lemice!

**Shaunb2000** · 04-24-2013, 06:26 PM

Hey Lemice,

I'm looking at the spreadsheet today and some of the data I entered yesterday have today's date. Is there any way to make the date stay on the date the data was entered?

Thanks again,

**Lemice** · 04-24-2013, 06:31 PM

The only way I can think of, is that you copy the range of data before the day pass, then right click somewhere else (or go Edit), "Paste Special...", choose "Value".

This way Excel will make the new data you just created pure number / text.