On Thu, 5 Feb 2009 08:13:00 -0800, srctr
wrote:

I am having trouble with the formula. When I paste it into the cell I get an
error "The formula you typed as an error" message on the (Year which is
directly following AsOfDate+1-DAY(AsOfDate),DATE(YEAR(

??
--
cao


Some newsgroup readers -- and Google Groups is notorious for this -- put extra
formatting symbols within posts. Usually not a problem but can really screw up
long formulas.

Try removing the line feeds at the end of each line after you've pasted in the
formula.

And try pasting the formula into the formula bar rather than into the cell.
--ron