Recognizing Fall,Spring,Summer
 

I have the follwing situation:

Fall semester:
if the account start date (Acctstrt) is equal to or greater than
09/01/2008 and the account stop date (Acctstop) is less than or equal to
01/15/2009 than = Fall

Spring semester:
If (Acctstrt) date greater than or equal to 1/15/2009 and an Acctstop date
of 5/31/09.
= Spring

Summer semester:
if (Acctstrt) 06/01/2009 and the (Acctstop) 8/31/2009.
= Summer

Recognizing Fall,Spring,Summer
 

interesting situation.
what's your question?
susan


On Jan 28, 3:46*pm, Cazumel wrote:
I have the follwing situation:

Fall semester:
if the account start date (Acctstrt) is equal to or greater than
09/01/2008 and the account stop date (Acctstop) is less than or equal to
01/15/2009 than = Fall

Spring semester:
If (Acctstrt) date greater than or equal to 1/15/2009 and an Acctstop date
of 5/31/09.
= Spring

Summer semester:
if (Acctstrt) 06/01/2009 and the (Acctstop) 8/31/2009.
= Summer

Recognizing Fall,Spring,Summer
 

Check your other postings.
This question has been answered at least twice.

--
Gary Brown


"Susan" wrote:

interesting situation.
what's your question?
susan


On Jan 28, 3:46 pm, Cazumel wrote:
I have the follwing situation:

Fall semester:
if the account start date (Acctstrt) is equal to or greater than
09/01/2008 and the account stop date (Acctstop) is less than or equal to
01/15/2009 than = Fall

Spring semester:
If (Acctstrt) date greater than or equal to 1/15/2009 and an Acctstop date
of 5/31/09.
= Spring

Summer semester:
if (Acctstrt) 06/01/2009 and the (Acctstop) 8/31/2009.
= Summer

Recognizing Fall,Spring,Summer
 

Sorry still not sure how to put the formula for instance In Cell

A1 A2 A3 A4
A5 A6
Fall Spring Summer
Aptbegdt
Acctstrt Acctstop
5/31/2009 Formula here 9/1/2008
5/31/2009



"Cazumel" wrote:

I have the follwing situation:

Fall semester:
if the account start date (Acctstrt) is equal to or greater than
09/01/2008 and the account stop date (Acctstop) is less than or equal to
01/15/2009 than = Fall

Spring semester:
If (Acctstrt) date greater than or equal to 1/15/2009 and an Acctstop date
of 5/31/09.
= Spring

Summer semester:
if (Acctstrt) 06/01/2009 and the (Acctstop) 8/31/2009.
= Summer

Recognizing Fall,Spring,Summer
 

I got the answer thank you very much

"Cazumel" wrote:

I have the follwing situation:

Fall semester:
if the account start date (Acctstrt) is equal to or greater than
09/01/2008 and the account stop date (Acctstop) is less than or equal to
01/15/2009 than = Fall

Spring semester:
If (Acctstrt) date greater than or equal to 1/15/2009 and an Acctstop date
of 5/31/09.
= Spring

Summer semester:
if (Acctstrt) 06/01/2009 and the (Acctstop) 8/31/2009.
= Summer

Recognizing Fall,Spring,Summer
 

I got the answer thank you very much

"Cazumel" wrote:

Sorry still not sure how to put the formula for instance In Cell

A1 A2 A3 A4
A5 A6
Fall Spring Summer
Aptbegdt
Acctstrt Acctstop
5/31/2009 Formula here 9/1/2008
5/31/2009



"Cazumel" wrote:

I have the follwing situation:

Fall semester:
if the account start date (Acctstrt) is equal to or greater than
09/01/2008 and the account stop date (Acctstop) is less than or equal to
01/15/2009 than = Fall

Spring semester:
If (Acctstrt) date greater than or equal to 1/15/2009 and an Acctstop date
of 5/31/09.
= Spring

Summer semester:
if (Acctstrt) 06/01/2009 and the (Acctstop) 8/31/2009.
= Summer