Using RoundDown function in a Macro

[maacmaac]

I have formula as follows that I am trying to use in a Macro. It is working fine as a function by itself.

Please Login or Register  to view this content.

I want to use the same formula within a macro. I tried a number of different ways to code, but can't get any of them to work. May latest attempt was as follows:

Please Login or Register  to view this content.

Thank you in advance for any assistance.

[DonkeyOte]

Not really clear what you're doing ... are you trying to return the complete years from date in E to current date ?

Using your current approach perhaps:

Please Login or Register  to view this content.

Date being VBA equiv to Today()

If you are always going to round down to nearest whole number you could alternatively just use Int rather than RoundDown.

[JBeaucaire]

Your formula looks odd to me. Can you give me an example of the dates in column E and the desired result?

[maacmaac]

I am trying to rounddown to the nearest whole number (or nearest whole year). Column E contains a date.

So if the date in column E is 01/27/2011, and today's date is 7/27/2009, that is 549 days difference (~ 1 1/2 years). I need the forumla to return a value of 1 (rounds down to the nearest year).

The rounddown formula did work perfect. I did try using the INT function in my Macro but could not get it working. Used following code:

Please Login or Register  to view this content.

I would be interested as to why I couldn't get the code working with the INT function.

[JBeaucaire]

Like this then:

Please Login or Register  to view this content.

No, that's not right, try this:

Please Login or Register  to view this content.

[maacmaac]

Second code from JBeaucaire works perfect (as did the code from DonkeyOte). Thanks.