View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Cazumel Cazumel is offline
external usenet poster
 
Posts: 23
Default 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