+ Reply to Thread
Results 1 to 10 of 10

fixing today's date

  1. #1
    Registered User
    Join Date
    10-05-2010
    Location
    S.A
    MS-Off Ver
    Excel 2007
    Posts
    99

    fixing today's date

    good evening
    cell A1 has any data
    cell B1 is my conditional formula
    which is if I have number in A1
    then B1 will disply today's data
    the formula is:
    =IF(ISNUMBER(A1),TODAY(),"")
    until now it's working fine, but next day
    date will be changed, I want this date to be fixed
    I tried now instead of today
    but still date is changing
    anyone can help
    thanks in advance

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: fixing today's date

    I assume that you are attempting to create a datestamp for when a number is entered?

    If so,try pasting the following code into the appropriate sheet tab in the VBA editor (Alt F11) - Sheet1 for instance.

    Please Login or Register  to view this content.
    The code fires whenever the value in A1 changes and puts in a today's date as a static value.
    Martin

  3. #3
    Registered User
    Join Date
    10-05-2010
    Location
    S.A
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: fixing today's date

    thank you mrice for your quick reply
    but if I want to implement this in both columns A & B
    so that if I insert number in any cell in column A
    corresponding cell in column B will be filled automatically with
    today's date (fixed, not changed later on)
    thanks

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: fixing today's date

    Bens mod:
    Please Login or Register  to view this content.
    If the worksheet isn't protected, the cell can still be changed manually.
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    10-05-2010
    Location
    S.A
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: fixing today's date

    thank you Proton
    it's working fine

  6. #6
    Registered User
    Join Date
    06-05-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: fixing today's date

    This works well can it also be used for say alpha numeric data b123?

  7. #7
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: fixing today's date

    To make this work with any data (alphanumeric or numeric) try

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    06-05-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: fixing today's date

    Sorry to but in but I have tested and do not get it to work. I want to do the same but enter the date in column A when data is entered into Column B. It will be alpha numeric.
    I tested the code and tried using your colums 1st but it did not give me a result.

  9. #9
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: fixing today's date

    @fionaby
    You should have received this message back on Jun 2/2012 for your post #6.

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

  10. #10
    Registered User
    Join Date
    06-05-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: fixing today's date

    Will do thanks

+ Reply to Thread

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