+ Reply to Thread
Results 1 to 2 of 2

=if(and using multiple date criteria

  1. #1
    Registered User
    Join Date
    10-22-2021
    Location
    Springfield, Missouri
    MS-Off Ver
    365
    Posts
    14

    Question =if(and using multiple date criteria

    I am trying to write an IF(AND formula using dates where all 3 dates must meet the criteria <=TODAY() to return an "Y" value.

    The other option is to write an IF formula where if any of the dates are blank, it returns a "N" value. If all of the cells have dates, it returns
    a "Y" value. I could use some help. I have tried multiple versions and cannot seem to get the right syntax. A sample file is attached. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,668

    Re: =if(and using multiple date criteria

    Formula for Option 1: =IF(AND(G2<=TODAY(),I2<=TODAY(),K2<=TODAY()),"Y","N") and copy down
    Option 2: =IF(AND(G2<>"",H2<>"",I2<>"",J2<>"",K2<>""),"Y","N") and copy down
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 5
    Last Post: 04-21-2020, 11:36 AM
  2. Multiple criteria formula with date as criteria
    By Phlegon_of_Tralles in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-06-2019, 09:27 PM
  3. Count with multiple criteria (Date, Time and Other Criteria)
    By Naren_Kumar in forum Excel General
    Replies: 6
    Last Post: 06-25-2018, 05:53 PM
  4. [SOLVED] Index Match with multiple criteria and date criteria
    By snolem75 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2018, 03:51 PM
  5. Replies: 16
    Last Post: 01-05-2018, 11:04 PM
  6. Replies: 4
    Last Post: 04-28-2017, 11:06 AM
  7. Week to Date / Month to Date with Multiple Criteria
    By marcojhb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-31-2016, 01:51 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1