Results 1 to 8 of 8

Check multiple dates in range

Threaded View

chaliseyp Check multiple dates in range 03-18-2021, 08:03 PM
Gregb11 Re: Check multiple dates in... 03-18-2021, 09:51 PM
chaliseyp Re: Check multiple dates in... 03-22-2021, 06:46 PM
kvsrinivasamurthy Re: Check multiple dates in... 03-19-2021, 12:37 AM
chaliseyp Re: Check multiple dates in... 03-22-2021, 06:39 PM
Gregb11 Re: Check multiple dates in... 03-22-2021, 06:50 PM
kvsrinivasamurthy Re: Check multiple dates in... 03-23-2021, 01:41 AM
bebo021999 Re: Check multiple dates in... 03-23-2021, 03:03 AM
  1. #1
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    78

    Thumbs up Check multiple dates in range

    HI,

    I want to have a formula to check if the start date and finish date are correct.

    For it to be correct, the start date (for example on Strategic) on P50 should be equal or less than the P50 and start date of P50 should be equal or less than start date of P90. Similarly, P50 finish date should be more or equal to base finish date and P90 finish date should be more or equal to the P50 finish date.

    This should also accordingly apply for the dates of concept, delivery readiness delivery and finalisation.


    How can we set up formula for this?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. check missing dates in range delete in another range
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2020, 03:04 PM
  2. Check if date range contains any of the dates in a list
    By mirazojm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-04-2020, 05:45 AM
  3. Check if range of dates fall between two dates
    By Wasilsky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2017, 08:40 AM
  4. [SOLVED] Need to check if cell value is equal to a named range (of dates)
    By chiidzzz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-19-2017, 11:50 AM
  5. [SOLVED] Check a date to find if it falls between a range of dates
    By Kausch in forum Excel General
    Replies: 3
    Last Post: 10-21-2014, 07:56 AM
  6. Check dates in range either same dates or different dates by formula
    By breadwinner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 07:42 AM
  7. check if dates fall within a range
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2011, 01:15 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