Can Mod return a decimal?

[yellephant]

I'm admittedly lacking in VBA savvy, so apologies if this is an easy fix, but is there any way to get the Mod operator to return a decimal result? For instance, I'd like this:

Please Login or Register  to view this content.

To assign ToChange to be 5 as of right now, in June. Is there a way to do this?

Thanks in advance!

[chergh]

No the mod function cannot return a decimal.

Mod only works with integers so any real numbers (those with deciamals) are rounded before performing the modulo function.

[yellephant]

Bummer. I suppose working around it manually won't be too rough, just nowhere near as elegant as a one-line solution.

Thanks for the quick response, though, chergh!

[Andy Pope]

What exactly are you trying to do?

[yellephant]

Essentially, I'm trying to do what my bit of sample code implies. Here's the rundown:

I have a worksheet with a range of dates in the format "yyyy.mm", but the dates themselvse are formatted as numbers, because that's how they're output by a SAS program. I want to have a macro look at the last of the dates, the most recent, and compare it to today's date, then tell me how many months separate the two dates.

Right now, I see errors in my code's logic.

Here's my new attempt:

Please Login or Register  to view this content.

I think that might work. I'm trying to hash out a problem with For Each ... Next loops right now.

[Andy Pope]

How about converting the information to a date?

Please Login or Register  to view this content.