Excel 2007 between date range formula

Posted on 2010-01-06
Last Modified: 2013-11-25
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.

Question by:aplona
    LVL 81

    Accepted Solution


    LVL 50

    Expert Comment

    by:barry houdini
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    Prime numbers are natural numbers greater than 1 that have only two divisors (the number itself and 1). By “divisible” we mean dividend % divisor = 0 (% indicates MODULAR. It gives the reminder of a division operation). We’ll follow multiple approac…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now