Create DATEDIF as a User Defined Function in Excel 2010

I know how to use DATEDIF in Excel.
I would like to create a User Defined Function for DATEDIF
mnoisetteAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Patrick MatthewsConnect With a Mentor Commented:
With respect, I think this is a very, very bad idea.

Assuming that you are putting your DateDif UDF into the current workbook, then to use the UDF and not the native Excel function, you have to qualify the function call with the module name:

=Name_of_module.DateDif(<arguments>)

I fail to see how that is an improvement.  You should just use a different name for your UDF.
0
 
Saqib Husain, SyedEngineerCommented:
Is this homework?
0
 
mnoisetteAuthor Commented:
No, a project. I use the formula all the time. Would be easier to use as a UDF.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.