Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 19th 13, 04:41 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 2
Thumbs up Help creating new functions for Excel 2013

Does anyone know how to create new functions?

I am trying to write a formula that will return the Date Modified for 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 my task as complete.

Can anyone help?

  #2   Report Post  
Old August 19th 13, 04:53 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,695
Default Help creating new functions for Excel 2013

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
  #3   Report Post  
Old August 19th 13, 06:10 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 2
Default

Quote:
Originally Posted by Claus Busch View Post
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,

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.
  #4   Report Post  
Old August 19th 13, 06:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,695
Default Help creating new functions for Excel 2013

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
  #5   Report Post  
Old August 20th 13, 01:25 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 524
Default Help creating new functions for Excel 2013

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does Publisher 2013 have autoflow? Martin [_2_] Excel Discussion (Misc queries) 0 March 12th 13 04:22 PM
Update calendar for 2013 - 2020 with events from the database sheet ganzzu Excel Programming 0 February 15th 13 01:22 PM
Creating VBA Functions When Creating Spreadsheet Via VBA? PeteCresswell[_2_] Excel Programming 6 June 18th 07 12:38 PM
creating a excel spread sheet using ffinancial functions slide show Excel Worksheet Functions 1 September 8th 05 08:46 PM
I have had difficulty in creating user defined functions in Excel MichaelG Excel Worksheet Functions 3 July 13th 05 11:59 AM


All times are GMT +1. The time now is 05:03 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017