+ Reply to Thread
Results 1 to 3 of 3

Using IF/AND statement for dates

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    North Carolina
    MS-Off Ver
    Office 2016
    Posts
    1

    Unhappy Using IF/AND statement for dates

    Good day!

    I hope someone can assist me with the following problem

    I am trying to get a return value of Yes/No indicating if the customer is active for the current month based on the following (which are all dates)

    Example 1
    Contract Start Date: 01/01/2014
    Contract End Date: *blank*
    Current Month: 09/01/2019

    In this case, the customer the customer is active for 9/2019.

    Example 2
    Contract Start Date: 03/01/2016
    Contract End Date: 08/31/2019
    Current Month: 09/01/2019

    In this case, the customer the customer is NOT active for 9/2019.

    Can someone please assist. I am really frustrated. Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Usine IF/AND statement for dates

    Hi,

    Paerhaps with thosed dates in columns A:C in D1

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Using IF/AND statement for dates

    =IF(OR(AND(B1="",A1<=EOMONTH(C1,0)),AND(B1>=C1,A1<=EOMONTH(C1,0))),"Yes","No")
    Last edited by davsth; 09-24-2019 at 06:07 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Statement with dates
    By Phlegon_of_Tralles in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-22-2019, 12:31 PM
  2. [SOLVED] IF OR Statement with Dates
    By Webbers in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-24-2015, 09:18 AM
  3. If statement using dates.
    By CL-West in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-16-2014, 06:20 AM
  4. If Statement and dates
    By Cageyj0nny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2014, 08:03 AM
  5. If statement with Dates
    By ktkreeger in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-02-2013, 04:26 PM
  6. IF STATEMENT and Dates
    By gballard in forum Excel General
    Replies: 6
    Last Post: 05-30-2012, 03:31 PM
  7. Help with if statement with dates
    By jmoore1197 in forum Excel General
    Replies: 4
    Last Post: 10-06-2009, 03:10 PM

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