<div>
When you say &quot;date range&quot; do you mean that the 2 dates will be specifically one of those exact ranges or that it would fall into one of those ranges?<br />
regards, barry<br />

</div>


When you say "date range" do you mean that the 2 dates will be specifically one of those exact ranges or that it would fall into one of those ranges?
regards, barry


<div>
<div class="content wysiwyg-content">
Hello experts,<br />
&nbsp; &nbsp;Here is what i'm trying to do. &nbsp;I have and excel 2007 sheet. &nbsp;A1 and B1 have dates in them. &nbsp;I need a function that will state if date is between 01/01/1990 and 09/30/2009 then C1 = 3, if date reange is between 10/01/2009 and 10/31/2009 then C1 = 1, If date range is between 10/01/2009 and 11/30/2009 then C1=2, if date range is between 10/01/2009 and 12/31/2009 then C1=3. <br />
<br />
Thanks
</div>
</div>


Hello experts,
   Here is what i'm trying to do.  I have and excel 2007 sheet.  A1 and B1 have dates in them.  I need a function that will state if date is between 01/01/1990 and 09/30/2009 then C1 = 3, if date reange is between 10/01/2009 and 10/31/2009 then C1 = 1, If date range is between 10/01/2009 and 11/30/2009 then C1=2, if date range is between 10/01/2009 and 12/31/2009 then C1=3. 

Thanks

Excel 2007 between date range formula

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

An algorithm is a self-contained step-by-step set of operations to be performed. Algorithms exist that perform calculation, data processing, and automated reasoning. Starting from an initial state and initial input (perhaps empty), the instructions describe a computation that, when executed, proceeds through a finite number of well-defined successive states, eventually producing "output" and terminating at a final ending state. The transition from one state to the next is not necessarily deterministic; some algorithms, known as randomized algorithms, incorporate random input.