Results 1 to 6 of 6

Assistance with Array Function for Date Calculation

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2016
    Posts
    12

    Exclamation Assistance with Array Function for Date Calculation

    Hi all,

    I've created a spreadsheet full of formulas to work out dates for meetings and when to call for papers, etc. One of the columns is calculated from a rigid set of dates using an array formula, whereas everything else is calculated from the main input date. I need assistance to make the array function work better.

    At the moment, I'm using the MAX function with <, it is picking the nearest date before the date in row K. When using MIN and >, it gives me the nearest date after row K. I'm trying to make it so that the date which appears in row D is the nearest date on the SMTDates range regardless of past or future so long as it falls between the dates in rows C and F. I've tried utilising the INDEX function, but have been unable to make that work to any great effect either.
    Attached Files Attached Files
    Last edited by Kitsune; 07-27-2017 at 11:49 AM. Reason: Added sample workbook

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculation / Formula Assistance
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2016, 10:59 AM
  2. [SOLVED] Date Function (Rent calculation)
    By Naseeer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2015, 12:31 AM
  3. [SOLVED] Assistance with Minimum Length array function
    By arkan01d in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2014, 09:09 PM
  4. COUNT/COUNTIF function with date calculation
    By Jayana in forum Excel General
    Replies: 4
    Last Post: 05-28-2012, 01:19 AM
  5. IF and SUM Column Calculation assistance
    By MJLX in forum Excel General
    Replies: 12
    Last Post: 07-07-2009, 04:53 PM
  6. Calculation assistance please
    By Danny William in forum Excel General
    Replies: 7
    Last Post: 07-16-2008, 01:30 PM
  7. Help With Date Calculation Function
    By dvent in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2008, 10:13 AM

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