Calculating and Formatting Month/Year

[Guest]

Hello,

I need a formula that will calculate the previous month, but appear as a the
month and year not the date.

Please help!
Thanks,

M

 

[Duane Hookom]

Could you put this into a specification that has input, calculations, and
desired results? Examples would help.

 

[Guest]

Hi Duane,

The reports are processed monthly for the state tax boards. At the top of
the page, they request the month and year of the information reported.
Because the report is run in the following month, I need a formula that would
automatically enter the prior month.

For instance, I uploaded February's data today (3/8/06). On the top of the
sheet, I would like for a formula to enter "February 2006."

I've been hand entering the month on 20 or so reports. If there is no way
around it, I will continue.

Thanks,

Mel

 

[Duane Hookom]

Don't you have data in your report with a date field that can be displayed
with just the month and year?

If not, you can add a text box:
Control source: =DateAdd("m",-1,Date())
Format: mmmm yyyy