Results 1 to 8 of 8

Condition fixed for text between two dates

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2015
    Location
    Woking, England
    MS-Off Ver
    2010
    Posts
    72

    Condition fixed for text between two dates

    Sir,

    if end date are covered form 02.03.2015 to 05.03.2015 the value return is Meeting01. In-case Start date(05.03.2015) end date are covered next meeting from

    Meeting02 to Meeting05 the value return is 0.Start Date(A) End date(B) date are covered next month the value return is "Data Not Available form the table".

    if end end date are back date value return is "Check Entry".(Start Date 31.03.2015 but End Date is 28/03/2015).

    please help me.file attached.
    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. Blank Dates - Group by: fixed in 2010?
    By MelissaGregory in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-05-2014, 10:35 AM
  2. convert dates to a one fixed date
    By legolas in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-16-2013, 10:55 AM
  3. [SOLVED] IF Condition: two cells with dates and concatenation of corresponding 2 text cells
    By desibird in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-25-2013, 10:38 AM
  4. Fixed Width Text to Excel with fixed break lines.
    By jameel30 in forum Word Formatting & General
    Replies: 1
    Last Post: 08-10-2012, 08:57 PM
  5. Replies: 1
    Last Post: 06-25-2012, 12:45 AM
  6. Condition code cells that contains text and dates
    By virencm in forum Excel General
    Replies: 4
    Last Post: 12-30-2011, 06:35 AM
  7. Auto fixed dates in action log
    By jupfold in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-16-2009, 11:03 AM
  8. [SOLVED] Charting data against dates where dates are not at fixed intervals
    By PK in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-16-2005, 01:05 AM

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