View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default Formula - Period Quarter End

I Need a formula to give me the period quarter end. The date fields I have
to use in the formula a

Cell B35: 2007

Cell B54 (references period.year): 007.2007

I would like results to show as: 006 / 2007
The formula needs to take into account cross years, so if data was pulled
for February 2007, the "Period Quarter End" would be 12 / 2006.

Here is the formula I was trying to use. Obviously, it doesnt work.

=IF(AND(LEFT(B54,3)6,LEFT(B54,3)<10),006 / B35,"")

Any ideas???