LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dates for European Summer Time Victor Delta[_2_] Excel Discussion (Misc queries) 6 March 25th 10 10:17 AM
Student Roster - fall, spring,summer, winter? Cazumel Excel Worksheet Functions 7 June 10th 08 06:28 AM
problemer med å summer klokkeslett S.N.K Excel Discussion (Misc queries) 0 December 12th 07 12:06 AM
Is a date in summer or winter? Thea Excel Worksheet Functions 3 April 27th 07 12:12 AM
Ah, Summer is coming & I need help with camp attendances Mustanganna Excel Worksheet Functions 1 June 30th 06 07:31 PM


All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"