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?

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.
Similar Threads
  1. Dianne

    New to functions

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

    About Excel Functions

    Flintstone, Nov 2, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    84
    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:
    134
    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:
    102
    Mikjall777
    Aug 11, 2006
  5. divahammer

    Please help with finding correct functions!!!

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

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

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

    help with string functions please

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

    Help in EXCEL functions - needed badly

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