Hello, I'm trying to make a base period form from a (Start Date) I enter that would show the first four of five completed calendar quarters prior to the date (Start Date)
EXAMPLE:
(Start Date) = 11/16/2012
June 30-2012 To April 1-2012
March 31-2012 To January 1-2012
December 31-2011 To October 31-2011
September 30-2011 To June 30-2011
I wanted to enter the start date in cell (A1) then have the quarters follow in the text/date format.
(A1) = Start date
Cell (A3) = June 30-2012 To April 1-2012
Cell (A4) = March 31-2012 To January 1-2012
Cell (A5) = December 31-2011 To October 31-2011
Cell (A6) = September 30-2011 To June 30-2011
Thanks!!!
EXAMPLE:
(Start Date) = 11/16/2012
June 30-2012 To April 1-2012
March 31-2012 To January 1-2012
December 31-2011 To October 31-2011
September 30-2011 To June 30-2011
I wanted to enter the start date in cell (A1) then have the quarters follow in the text/date format.
(A1) = Start date
Cell (A3) = June 30-2012 To April 1-2012
Cell (A4) = March 31-2012 To January 1-2012
Cell (A5) = December 31-2011 To October 31-2011
Cell (A6) = September 30-2011 To June 30-2011
Thanks!!!