Formula - Period Quarter End
I received a formula that works.
Thanks for the help.
=IF(ROUNDUP(A1/3,0)=1,"012 /
"&YEAR(NOW())-1,TEXT((ROUNDUP(A1/3,0)-1)*3,"000")&" / "&YEAR(NOW()))
"Barb Reinhardt" wrote:
Let's say the date field you are referencing is C17. (has February 2007)
=TEXT(IF(MONTH(C17)<6,12,6),"000") & " / " &
IF(MONTH(C17)<6,YEAR(C17)-1,YEAR(C17))
HTH,
Barb Reinhardt
"Sam" wrote:
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???
|