I think you got a parenthetical in the wrong place.
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())),"mmmm")
should be
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())),"mmmm")
--
John C


"Pete_UK" wrote:

Try this:

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())),"mmmm")

This will change (potentially) every day.

Hope this helps.

Pete

On Aug 20, 9:52 pm, drose wrote:
I have a form that I fill out each month for the previous month. Is there a
way or formula to automatically have the previous month post?