nested if statement and dates

August 25, 2011 at 22:19:22
Specs: Windows 7
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....

See More: nested if statement and dates

August 26, 2011 at 01:57:06
With you Quarter start dates in e.g. C1:C4, something like this should work:


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question