Calculate the number of Months between two Dates (DATEDIF M)

[sweetbomb]

Greetings,

I am trying to calculate the number of months between two cells within my spreadsheet using VBA but I am having issues...

What I would like to do is find the Date1 and Date2 in their respective columns cells and out the months to the respective column cell.

Column AN (Starting in Cell 7) = Date1
Column AP (Starting in Cell 7 ) = Date2
Column AO (Starting in Cell 7 ) = Months between Date1 and Date2

I can use this code in each cell to do it but I want to be able to do this with VBA

Please Login or Register  to view this content.

What I tried and I know its wrong but thought I would post it.

Please Login or Register  to view this content.

[nigelog]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[PCI]

See next UDF

AO7 =DateDiffPerso(AN7,AP7)
Copy and paste down as needed

Please Login or Register  to view this content.

[sweetbomb]

Awesome, I used the Test2 and it worked great. One further question, is there a switch I can use to run Test2 when ever something is entered in Column AN and AP?

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[nigelog]

Maybe

Please Login or Register  to view this content.

[sweetbomb]

Hi and thank you,

I want to be sure that this only runs on two of my worksheets. The Month and Report worksheets. Not all of the other 9 or so worksheets in my workbook.

Maybe

Please Login or Register  to view this content.

[nigelog]

Place in the worksheet module of the sheets you want - by right click sheet tab - view code

[sweetbomb]

Hi, when I do that I get a Debug error from another script I am running across the workbook.

It breaks the below: At Worksheets(WSname)

Please Login or Register  to view this content.

[nigelog]

Your Sub name suggest making the array sheets visible so would not

Please Login or Register  to view this content.

be correct

Please Login or Register  to view this content.

appears to be hiding?

And code in a worksheet module should not affect this code which I assume is in a module

[sweetbomb]

I had some other junk code on the other Worksheets VBA area. I removed it and it works great thank you for all your help!

[nigelog]

No problem .. glad to have helped

Thankyou for the feedback and rep