Let's say the current period is in cell A1

The current quarter could be derived as:

=ROUNDUP(A1/3,0)

and the previous quarter would be:

=IF(ROUNDUP(A1/3,0)=1,4,ROUNDUP(A1/3,0)-1)

If the previous quarter is 4, then the previous year is current year -1

The quarter end would be 3 x quarter: 3 x Q1 = 3 = March; 3 x Q2 = 6 = June;
etc

Similarly for previous quarter end.

Not sure if that helps or works with your existing formulae

Regards

Trevor


"Sam" wrote in message
...
I am trying to find a formula to give me the Previous Quarter End. The
headers on the spreadsheet look as follow:

Acct # Curr Period Prev Qtr End Prev Period Curr Period Prev Yr
2134 007 ? 006 007 /
2006

The report is refreshed frequently, but here is a sample of how the data
format that is populated for the date fields.

Period: 007.2007
Year: 2007

There are 12 periods in the year and 4 quarter ends (The quarter end are
March, June, September, and December)

I have formulas for all the fields except the previous quarter end (12 /
2006, 003 / 2007, 006 / 2007, 009/2007). In the example above, the
previous
quarter end date would 006 / 2007.

Any clues.