I need the current month - 1 to display in Excel using VBA.
I tried this in my template
Month(today())-1 and it gives what looks like a month (ie...for current it's 7) but when I change the format to mmmm then it displays January. Basically it looks like it's having the month be the day. Anyway, can someone help me please please please? I don't care if it's in the excel template or in my vba code. Either one will do. Thanks - you guys rock.