Results 1 to 3 of 3

If Formula Help Date Range

Threaded View

  1. 07-17-2017, 05:05 PM #1
    Hoover5896
    Hoover5896 is offline
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    74

    If Formula Help Date Range

    Hello,

    In the attached workbook, I am trying to make an IF formula so if the date in A1 and down is less than 01/01/2017, it returns a 1 in cell B1. I am not sure if I have to format the formula differently for it to know I am typing a date in the IF formula. Can someone please help?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to check if a date falls within a date range, then returns a corresponding cell
    By pjsween in forum Excel General
    Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  2. Function/Formula to extra rows from one range based on a date period to another range?
    By Norcal1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2015, 03:00 AM
  3. [SOLVED] how to match one date range with another date range -formula
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-05-2014, 06:18 PM
  4. [SOLVED] Apply formula to one date range, another to another date range
    By Caulerpa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2014, 11:04 AM
  5. nested IF formula to return a number if a date falls within a given date range
    By swissmiss in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  6. Formula for determining if two date columns fall within specific date range
    By Igottabeme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2006, 09:55 PM
  7. Formula for determining if two date columns fall within specific date range
    By Igottabeme in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 05:10 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1