Recognizing Fall,Spring,Summer

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
 
C

Cazumel

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
 
C

Cazumel

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...
 

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
Minus Dates 5
Form return lookup values 1
How to set a button to filter a table using specific from and tocells data 4
How many days fall in each month? 4

Top