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?
|