ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS (https://www.excelbanter.com/excel-worksheet-functions/144614-how-do-i-set-up-excel-automatically-enter-date-into-cells.html)

Danielle

HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS
 


Peo Sjoblom

HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS
 
If you want an answer you should really avoid all caps and post a question
in the body of the message and not only in the subject line. This comes
across as rude and nonchalant (all caps mean shouting for instance). You
should also explain a little bit more what you want to happen, your question
does not make any sense to me.

--
Regards,

Peo Sjoblom

"danielle" wrote in message
...




Gord Dibben

HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS
 
Which cells and when?

Today's date can be updated each day if you use =TODAY() in A1l.

Then in A2 enter =A1+1

Drag/copy down as far as you wish.


Gord Dibben MS Excel MVP

On Wed, 30 May 2007 10:47:01 -0700, danielle
wrote:



JLatham

HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS
 
What Peo said: ditto

Apparently Gord came in on a different route and was able to see the entire
subject line. But I rode the short bus, oops, short train and could only see
"HOW DO i SET UP EXCEL TO AUTOMATICALLY ..." and so Peo and I could only
guess at your needs. In the future please remember that not everyone views
your request for help from the same location or with the same tools, so
breaking them up into a subject line and providing specifics within the body
of a message will help us to help you.

Don't feel too bad ... you're not the first, and won't be the last, to short
change yourself via "the system".

"Peo Sjoblom" wrote:

If you want an answer you should really avoid all caps and post a question
in the body of the message and not only in the subject line. This comes
across as rude and nonchalant (all caps mean shouting for instance). You
should also explain a little bit more what you want to happen, your question
does not make any sense to me.

--
Regards,

Peo Sjoblom

"danielle" wrote in message
...





Gord Dibben

HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS
 
Jerry

You're correct.

My Forte Agent shows the entire subject line...............

HOW DO i SET UP EXCEL TO AUTOMATICALLY ENTER DATE INTO CELLS

I rarely anymore bring up the ALL CAPS issue or the please post in the body.

If I can't get a handle on the subject from the subject line I generally ignore
and move on.


Gord




On Thu, 31 May 2007 12:20:03 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

What Peo said: ditto

Apparently Gord came in on a different route and was able to see the entire
subject line. But I rode the short bus, oops, short train and could only see
"HOW DO i SET UP EXCEL TO AUTOMATICALLY ..." and so Peo and I could only
guess at your needs. In the future please remember that not everyone views
your request for help from the same location or with the same tools, so
breaking them up into a subject line and providing specifics within the body
of a message will help us to help you.

Don't feel too bad ... you're not the first, and won't be the last, to short
change yourself via "the system".

"Peo Sjoblom" wrote:

If you want an answer you should really avoid all caps and post a question
in the body of the message and not only in the subject line. This comes
across as rude and nonchalant (all caps mean shouting for instance). You
should also explain a little bit more what you want to happen, your question
does not make any sense to me.

--
Regards,

Peo Sjoblom

"danielle" wrote in message
...







All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com