Results 1 to 6 of 6

Match dates for first next or previous

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Match dates for first next or previous

    I have a data table with dates and marks by 0 and 1.

    I need a formula, if a date selected from data table, to find first next or previous matched date.

    At attached table you can see all detail and explanation.

    Thanks in advance for any reply and valuable help.

    Refards,
    turist
    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. [SOLVED] Dates - countdown from last day of previous month
    By TheRobsterUK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2014, 12:06 PM
  2. [SOLVED] VBA Code for Previous dates
    By trosasco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2013, 11:11 AM
  3. [SOLVED] Working with previous dates in Excel
    By trosasco in forum Excel General
    Replies: 1
    Last Post: 05-29-2013, 01:44 AM
  4. [SOLVED] Highlight Group of Dates if Dates Match List of other Dates
    By martinpgibson in forum Excel General
    Replies: 5
    Last Post: 10-24-2012, 08:14 PM
  5. [SOLVED] Count dates for previous month
    By scribbler1382@yahoo.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2006, 03:45 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