Results 1 to 10 of 10

Calculate number of days between 2 dates & then assign a number based on the answer

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2009
    Location
    Ohio
    MS-Off Ver
    2010, 2013
    Posts
    11

    Question Calculate number of days between 2 dates & then assign a number based on the answer

    Can someone please help me create a spreadsheet with what I think will be a very simple formula?

    If date in B2 - date in A2 is 1 or less days, put a 1 in cell C2.
    If date in B2 - date in A2 is 7 or less days but more than 1, put a 2 in cell C2.
    If date in B2 - date in A2 is 30 or less days but more than 7, put a 3 in cell C2.
    If date in B2 - date in A2 is 90 or less days but more than 30, put a 4 in cell C2.
    If date in B2 - date in A2 is 91 days or more, put a 5 in cell C2.

    OR

    Another, maybe simpler, way of saying it is:

    If date in B2 - date in A2 is 1 or less days, put a 1 in cell C2.
    If date in B2 - date in A2 is 2-7 days, put a 2 in cell C2.
    If date in B2 - date in A2 is 8-30 days, put a 3 in cell C2.
    If date in B2 - date in A2 is 31-90 days, put a 4 in cell C2.
    If date in B2 - date in A2 is 91 days or more, put a 5 in cell C2.

    Thank you!
    Attached Files Attached Files
    Last edited by MrHappyGoLucky12; 03-22-2014 at 09:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to create a simple formula for a data dump
    By blue_izce8 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-07-2013, 06:32 PM
  2. how to create simple formula
    By rlc131993 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2012, 06:55 PM
  3. Trying to create a simple formula or VBA to buy or sell stock
    By MMcCawley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2012, 11:47 PM
  4. How do you create simple add/subtract formula?
    By Suomalainen in forum Excel General
    Replies: 6
    Last Post: 07-01-2008, 03:18 AM
  5. [SOLVED] i want to create a simple yes/no spreadsheet with a dot represent.
    By alaskatpj in forum Excel General
    Replies: 6
    Last Post: 04-23-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1