Results 1 to 10 of 10

question about TODAY function to not affect previous cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-28-2010
    Location
    Antwerp, Belgium
    MS-Off Ver
    Office 365
    Posts
    170

    question about TODAY function to not affect previous cells

    Hello,

    I'm maintaining a woorksheet with expenses.

    To simplify the case, I will have only two columns in the sheet.
    so everyday I fill in the expenses I made for the day.

    Column A will be the date of the input, column B will be the amount of money I spent on that date.

    What I need is that whenever I fill in the amount in column B, it will automatically fill in the date OF TODAY in the A cell (to save me the hassle of inputting the date manually).

    I tried to do it with "TODAY" function, so I inserted in cell A3 the following function: =IF(B3="","",TODAY())
    the problem is, that everyday it automatically changes the cells with the TODAY function (the function I showed above), to the date of today, also for the previous filled in cells. But what I need is, that it will leave the previous cells the way it was.

    I see 3 solutions (but don't know how to implement them):
    1. after the function inputs the date of today, it will automatically re-paste it AS VALUES.
    2. I need to do another IF, inside the existing IF function.
    3. I need to use another function.

    attached excel with the function as an example.

    Thank you.
    Attached Files Attached Files
    Last edited by whatever61; 05-28-2010 at 05:24 PM. Reason: Solution found

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1