ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE (https://www.excelbanter.com/excel-discussion-misc-queries/68983-how-create-formula-automatically-insert-date.html)

Quagmire

HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE
 
I am trying to build a formula & arguement for a spreadsheet fashioned after
a journal or daily log. What I want to have happen is for example, if I were
to type text into cell A1, cell A2 would display the date in which the text
was entered into cell A1. More or less a date stamp...I have tried several
different ways but excel does not like my attempts. Thanks in advance to
anyone who can help.

Niek Otten

HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE
 
http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten

"Quagmire" wrote in message
...
I am trying to build a formula & arguement for a spreadsheet fashioned
after
a journal or daily log. What I want to have happen is for example, if I
were
to type text into cell A1, cell A2 would display the date in which the
text
was entered into cell A1. More or less a date stamp...I have tried
several
different ways but excel does not like my attempts. Thanks in advance to
anyone who can help.





All times are GMT +1. The time now is 09:55 AM.

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