| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates for European Summer Time | Excel Discussion (Misc queries) | |||
| Student Roster - fall, spring,summer, winter? | Excel Worksheet Functions | |||
| problemer med å summer klokkeslett | Excel Discussion (Misc queries) | |||
| Is a date in summer or winter? | Excel Worksheet Functions | |||
| Ah, Summer is coming & I need help with camp attendances | Excel Worksheet Functions | |||
Threaded Mode
