I'm trying to automate some reporting and our company has been doing this manually. I can't seem to find a automated way to convert a numerical date ("5/2/2013") to just the month "May", then subtract a month "Apr", so I can put it in for reporting for the previous month's data.

Any ideas?

Thanks in advance!!