return last month's year

[bassima]

Hi Team,

How can i return last month's year in VBA

Such as if i ran it today it would return 2011 and next month it would return 2012.

in yyyy and yy

[shg]

One way:

Please Login or Register  to view this content.