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