Recognizing Fall,Spring,Summer

  • Thread starter Thread starter Cazumel
  • Start date Start date
C

Cazumel

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
 
Check your other postings.
This question has been answered at least twice.
 
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
 
I got the answer thank you very much

Cazumel said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 2
Student Roster - fall, spring,summer, winter? 6
Find then highlight in yellow 6
compare dates with different formats 2
Excel Substitution Help (a little complex) 2
Minus Dates 5
Termination within number of days 5
Form return lookup values 1

Back
Top