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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dianne

    New to functions

    Dianne, Jan 15, 2004, in forum: Excel Beginners
    Replies:
    4
    Views:
    130
    Norman Harker
    Jan 16, 2004
  2. Flintstone

    About Excel Functions

    Flintstone, Nov 2, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    66
    Frank Kabel
    Nov 2, 2004
  3. peter via OfficeKB.com

    Help me ! I want to create two or more functions work in one cell.

    peter via OfficeKB.com, Jun 26, 2005, in forum: Excel Beginners
    Replies:
    4
    Views:
    111
    peter dimitrakis via OfficeKB.com
    Jun 27, 2005
  4. Mikjall777

    Multiple functions in a cell help

    Mikjall777, Aug 10, 2006, in forum: Excel Beginners
    Replies:
    5
    Views:
    78
    Mikjall777
    Aug 11, 2006
  5. divahammer

    Please help with finding correct functions!!!

    divahammer, Aug 31, 2006, in forum: Excel Beginners
    Replies:
    5
    Views:
    83
  6. Mandi

    I'm cluesless - need help with "functions"?

    Mandi, Mar 25, 2008, in forum: Excel Beginners
    Replies:
    5
    Views:
    108
    Gord Dibben
    Mar 25, 2008
  7. KRK

    help with string functions please

    KRK, Jun 29, 2009, in forum: Excel Beginners
    Replies:
    4
    Views:
    75
    Ron Rosenfeld
    Jun 29, 2009
  8. kosageinusha18

    Help in EXCEL functions - needed badly

    kosageinusha18, Feb 4, 2010, in forum: Excel Beginners
    Replies:
    4
    Views:
    88
    kosageinusha18
    Feb 4, 2010
Loading...