Excel CRM date formula

  • Posted
  • Proposals 1
  • Remote
  • #16948
  • Expired
Guy V. has already sent a proposal.
  • 0

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.

Clarification Board

    There are no clarification messages.