• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5380
  • Last Modified:

Excel 2007 between date range formula

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
0
aplona
Asked:
aplona
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
=IF(B1<DATEVALUE("9/30/2009"),3,IF(B1<DATEVALUE("10/31/2009"),1,IF(B1<DATEVALUE("11/30/2009"),2,3)))

Kevin
0
 
barry houdiniCommented:
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
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now