Help creating new functions for Excel 2013

Discussion in 'Excel Beginners' started by Jschock, Aug 19, 2013.

  1. Jschock

    Jschock Guest

    Does anyone know how to create new functions?

    I am trying to write a formula that will return the Date Modified fo
    another cell. Does anyone know how to do this?

    I tried entering the formula =IF(C2="Complete", TODAY(), "")
    but that only returns me todays, date and not the date that I marked m
    task as complete.

    Can anyone help? :
     
    Jschock, Aug 19, 2013
    #1
    1. Advertisements

  2. Jschock

    Claus Busch Guest

    Hi,

    Am Mon, 19 Aug 2013 16:41:23 +0100 schrieb Jschock:
    TODAY() is a volatile function and shows always today. That means the
    value is changing every new day.
    You have to write your date manually or with VBA.


    Regards
    Claus B.
     
    Claus Busch, Aug 19, 2013
    #2
    1. Advertisements

  3. Jschock

    Jschock Guest

    Claus,

    How do I write the date with VBA? Can you explain this process to me
    I've been trying to read about it but am getting a bit lost
     
    Jschock, Aug 19, 2013
    #3
  4. Jschock

    Claus Busch Guest

    Hi,

    Am Mon, 19 Aug 2013 18:10:28 +0100 schrieb Jschock:
    if your "Complete" is in column C and the date should be in column D,
    then right click on sheet tab and paste the code into the code window:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("C:C")) Is _
    Nothing Then Exit Sub

    If Target = "Complete" Then _
    Target.Offset(0, 1) = Date
    End Sub

    In other case please post your table layout


    Regards
    Claus B.
     
    Claus Busch, Aug 19, 2013
    #4
  5. Jschock

    Stan Brown Guest

    Yes, of course. Google "excel user defined functions" (without
    quotes).
     
    Stan Brown, Aug 20, 2013
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.