Help creating new functions for Excel 2013

J

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

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

Jschock

Claus said:
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
 
C

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.
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Top