Formula is being quirky
where does the little square box show?
"Pierre" wrote:
On Jul 23, 3:30 pm, bj wrote:
a couple of issues.
10/31/08 should be fourth quarter
the 2009 comes from the month()9 portion
this is probably fiscal year starting Oct 1.
If it is the quarter designators may be the portion in error.
Oct through Dec might need to be Q1 rather than Jan thru Mar.
I think someone mistakingly combined calendar Year and fiscal yearinto one
equation
which do you need it to be?
bj:
Calendar year, and the other suggestions seem to work, albiet for a
little square box that appears within the answer.
Pierre
|