Macro to Calculate Date Difference

[Andrew.Trevayne]

Hi everyone.
Need to check with you guys as I'm really no good in VB Scripting or Macro.
I have a situation in which i need to calculate the difference between two dates on two different columns.
I know how to calculate the date difference using the formula
=DATEDIF(F5,E5, "M")

But what I need is to have this tiny button that I can click to return the difference between the two dates on a different column.
By the way I need the difference in months.
Please please please please please help me.
Thank's all.

[Leith Ross]

Hello Andrew.Trevayne,

Welcome to the Forum!

The VBA code is almost the same as the worksheet formula. Your example would translate to this in VBA...

  Dim dd As Integer

    dd = DateDiff("m", Range("E5"), Range("F5"))

[Andrew.Trevayne]

Thanks for the welcome.
Sadly I dont know how to use the formula you just gave, I really am NIL with regards to macro or Vb. I hope someone could further help?
Thanks again. Cheers.

[Andrew.Trevayne]

I hope somebody would be able to help me on the macro codes on this one.
I'm quite sure somebody knows how.. ^^

[akdrake]

Hi Lieth, I used the same code and the code runs but the results dont show. Do you know how I can show the answers?

[arlu1201]

Akdrake,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.