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? :)

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.

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

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