View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default formula for previous month

=today()-day(today())
will give the last day of the previous month.

Then you can format this cell to just show the month (or month and year):
mmmm yyyy



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?


--

Dave Peterson