formula for month(s) prior to actual
Just subtract from the month
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY")
will give you Oct2005
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY")
Sep2005
and so on
--
Regards,
Peo Sjoblom
"braadi" wrote in message
...
yesterday i asked for a formula that would give month and year prior to
actual based on excel time and date, and the answer i received worked. i
also need the formula(s) for months 2 and 3 prior to actual to provide
data
in a 3 month trend (i.e. a report generated in december would provide data
for october and september as well). i can't figure out how to tweak the
formula from yesterday to work.
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYY Y")
|