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? :) |
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 |
Quote:
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. |
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 |
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... |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com