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
     
    Jschock, Aug 19, 2013
    #1
    1. Advertisements

  2. Jschock

    Claus Busch Guest

    Hi,

    Am Mon, 19 Aug 2013 16:41:23 +0100 schrieb Jschock:

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


    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.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Aug 19, 2013
    #2
    1. Advertisements

  3. Jschock

    Jschock Guest

    Claus Busch;1613519 Wrote:
    > Hi,
    >
    > Am Mon, 19 Aug 2013 16:41:23 +0100 schrieb Jschock:
    > -
    > > I tried entering the formula =IF(C2="Complete", TODAY(), "")
    > > but that only returns me todays, date and not the date that I marke

    > my
    > > task as complete. -

    >
    > 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.
    > --
    > Win XP PRof SP2 / Vista Ultimate SP2
    > Office 2003 SP2 /2007 Ultimate SP2


    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
     
    Jschock, Aug 19, 2013
    #3
  4. Jschock

    Claus Busch Guest

    Hi,

    Am Mon, 19 Aug 2013 18:10:28 +0100 schrieb Jschock:

    > 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.


    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.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Aug 19, 2013
    #4
  5. Jschock

    Stan Brown Guest

    On Mon, 19 Aug 2013 16:41:23 +0100, Jschock wrote:
    >
    > Does anyone know how to create new functions?


    Yes, of course. Google "excel user defined functions" (without
    quotes).



    --
    Stan Brown, Oak Road Systems, Tompkins County, New York, USA
    http://OakRoadSystems.com
    Shikata ga nai...
     
    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.