View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default formula for previous month

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?