Results 1 to 7 of 7

Return "YES" or "NO" if a date in one worksheet is between two dates in another worksheet

Threaded View

eleonardo1213 Return "YES" or "NO" if a... 06-02-2016, 02:35 PM
mikeTRON Re: Return "YES" or "NO" if a... 06-02-2016, 03:16 PM
eleonardo1213 Re: Return "YES" or "NO" if a... 06-02-2016, 03:51 PM
FlameRetired Re: Return "YES" or "NO" if a... 06-02-2016, 04:04 PM
eleonardo1213 Re: Return "YES" or "NO" if a... 06-03-2016, 07:38 AM
FlameRetired Re: Return "YES" or "NO" if a... 06-03-2016, 08:40 PM
eleonardo1213 Re: Return "YES" or "NO" if a... 06-03-2016, 09:31 PM
  1. 06-02-2016, 03:51 PM #3
    eleonardo1213 is offline
    Registered User
    Join Date
    05-05-2016
    Location
    Syracuse, NY
    MS-Off Ver
    2013
    Posts
    4

    Re: Return "YES" or "NO" if a date in one worksheet is between two dates in another worksh

    Thank you! I have attached a smaller sample workbook (at least I tried to attach it - not sure if it will work). Also, I defined a name "DaysOff" for the area where the dates for the days off will be entered. Is that what you meant by making it standardized? The formula now reads =IF(AND(DaysOff>=B2,DaysOff<=C2),"YES","NO") If that's not what you meant

    Rotation Sample.xlsx
    Last edited by eleonardo1213; 06-02-2016 at 03:59 PM.
    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. Filter by "Confirmed" and by "Date (confirm or order)" copy and paste to "Invoice Audit"
    By celeazul in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  2. [SOLVED] Code Clean-Up: Delete "False" worksheet created when "Cancel" is chosen in Input Box
    By Kenny Blackwell in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-31-2015, 10:00 AM
  3. How to check if a range of cells contains the word "unresponsive" and return "yes" or "no"
    By benitopjuarez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. Return "green", "yellow" or "red" from date/age and priority ranking
    By Cantaloop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 12:12 AM
  7. Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank
    By DanBraden in forum Excel General
    Replies: 3
    Last Post: 02-16-2011, 02:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1