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.

Who is Participating?
zorvek (Kevin Jones)ConsultantCommented:

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
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.