formula for month that is prior to actual
i appreciate the help so much. look forward to getting this working now.
"Peo Sjoblom" wrote:
One way
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMM YYYY")
--
Regards,
Peo Sjoblom
"braadi" wrote in message
...
i generate reports for data collected from the previous month (i.e. in
december, i report for november's data). how do i formulate in my reports
the date to show the previous month and year (while automatically updating
according to excel date and time)?
|