|Im trying to write an if statement which will display, in a cell, an yearly quarter.|
I have a cell with a May 24, 2011 date (cell N7), I want to write an if statement where if the N7 date falls after May 1 (cell P2), but before August 1, 2011 (cell Q2), the result returned is 2 (cell S3).
If the same cell N7 has its date changed to August 24, 2011 the result returned is 3 (cell S3).
the quarters are divided as follows:
Q1 Feb 1 to April 31
Q2 May 1 to July 31
Q3 August 1 to Oct 31
Q4 November 1 to Jan 31
thanks to anyone who can help me out....