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
LVL 3
aplonaAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.