I am trying to create a little vba macro that calculates the number of the
month as well as the name of the month for use later in calculations. I
havethe following:
XLMonth = Month(Date)
XlMonth2 = Format(Date, "mmm")


So I figure I can if/then statement the whole thing, but it is the "else"
part that I am having trouble with. I need to move back a month (-1) if a
condition set earlier is met. But when I subtract (-1) from XlMonth I get
zero and noth 12. How do I work around this.