Excel CRM date formula
- or -
Post a project like this$$
- Posted:
- Proposals: 1
- Remote
- #16948
- Expired
Description
Experience Level: Intermediate
Im looking for a formula that would allow me to open one spreadsheet and the new time and date will be placed in a cell each time I open.
The old time and date will still be there where I have written comments of what happened yesterday. I have tried =now() but that only give you todays date and when you save you are given a different date and time when you open.
This what I want:
-------------------------------------------------------
24/01/10 20:41 Test test test 123 321
--------------------------------------------------------
Then I click save
Now it is the 25/01/10 and I reopen excel and see this
---------------------------------------------------------
24/01/10 20:41 Test test test 123 321
25/01/10 07:54
----------------------------------------------------------
I then type
24/01/10 20:41 Test test test 123 321
25/01/10 07:54 hahahahahah
--------------------------------------------------------
I then save.
Then when I reopen on the 26/01/10 I see this
--------------------------------------------------------
24/01/10 20:41 Test test test 123 321
25/01/10 07:54 hahahahahah
25/01/10 14:33
---------------------------------------------------------
I then type what I want on the new day.
This should take some one who knows excel inside out 5 min a guess.
Thanks for your bids. Looking for this asap.
The old time and date will still be there where I have written comments of what happened yesterday. I have tried =now() but that only give you todays date and when you save you are given a different date and time when you open.
This what I want:
-------------------------------------------------------
24/01/10 20:41 Test test test 123 321
--------------------------------------------------------
Then I click save
Now it is the 25/01/10 and I reopen excel and see this
---------------------------------------------------------
24/01/10 20:41 Test test test 123 321
25/01/10 07:54
----------------------------------------------------------
I then type
24/01/10 20:41 Test test test 123 321
25/01/10 07:54 hahahahahah
--------------------------------------------------------
I then save.
Then when I reopen on the 26/01/10 I see this
--------------------------------------------------------
24/01/10 20:41 Test test test 123 321
25/01/10 07:54 hahahahahah
25/01/10 14:33
---------------------------------------------------------
I then type what I want on the new day.
This should take some one who knows excel inside out 5 min a guess.
Thanks for your bids. Looking for this asap.
Gary B.
100% (3)Projects Completed
16
Freelancers worked with
16
Projects awarded
27%
Last project
27 Jul 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies