> Cell A1 contains a date,   say 30/04/2001

> Cell D4 currently has the following formula:
> =CONCATENATE("Period ended ",TEXT(A1,"dd mmmm yyyy"))
> which then displays  "Period ended 30 April 2001"

> Everything is perfect so far.

> In cell E4 I want a formula that will refer to cell A1 but display the
date
> less 1 year
> i.e.  "Prior Period, 30 April 2000"

> Can anyone help?   I've tried playing around with  YEAR  but not been
> successful.
> I am using Excel97

> Many thanks in advance,
> Dave Moore

> ="Prior Period, "&TEXT(DATE(YEAR(A1)-1,MONTH(A1),DAY(A1)),"dd mmmm yyyy")
> --
> Glenn Schwandt

> > Cell A1 contains a date,   say 30/04/2001

> > Cell D4 currently has the following formula:
> > =CONCATENATE("Period ended ",TEXT(A1,"dd mmmm yyyy"))
> > which then displays  "Period ended 30 April 2001"

> > Everything is perfect so far.

> > In cell E4 I want a formula that will refer to cell A1 but display the
> date
> > less 1 year
> > i.e.  "Prior Period, 30 April 2000"

> > Can anyone help?   I've tried playing around with  YEAR  but not been
> > successful.
> > I am using Excel97

> > Many thanks in advance,
> > Dave Moore