Help creating new functions for Excel 2013

[Jschock]

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

 

[Claus Busch]

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.

 

[Jschock]

Hi,

Am Mon, 19 Aug 2013 16:41:23 +0100 schrieb Jschock:
-

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.

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

 

[Claus Busch]

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.

 

[Stan Brown]

Does anyone know how to create new functions?

Yes, of course. Google "excel user defined functions" (without
quotes).