Month Header question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Day,

I have a report that I need to get the column header to say this.

The first one is easy, I have a text box with =format(date(),"mmm") to give
me todays month "Oct" , but now I want the next text box to see the previous
october and formulate that it would be the preceeding month "Sept" and so on
and so forth.

Can you help with the formula for this.

Thank you.
Lou
 
For the previous month, set the Control Source to:
=DateAdd("m", -1, Date())
and the Format property to:
mmm

Use -2 for the month before that, and so on.
 
Back
Top