Results 1 to 6 of 6

Formula to return dates into specific cell on another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Formula to return dates into specific cell on another sheet

    I have attached an example worksheet for your viewing.

    If you look at Sheet2 I would like to have a formula that looks at cells d3:l7 and if it finds it to have a number in that cell then it looks to the date above that column in (D1:L1) and places that date into Sheet1 under column c on the correct line.

    EX1: On DIR - Operational -- it has days 9/6 thru 9/9 checked on sheet 2
    I would like the formula to return 9/6, 9/7, 9/8, 9/9 into cell C3 on sheet1

    IF it could group the dates into a format like 9/6 - 9/9 it would be great I just need to show the dates of service in that column.

    Also sometimes we skip a couple days and then start up later in the same line so dates sometimes are would be 9/6 - 9/9, 9/15 - 9/28

    Can this be done
    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] Need formula to return a specific value if a specified date is between two other dates
    By BeachRock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2014, 02:03 PM
  2. Replies: 11
    Last Post: 11-30-2012, 08:04 PM
  3. Replies: 1
    Last Post: 08-07-2012, 03:07 PM
  4. Replies: 3
    Last Post: 06-20-2012, 07:16 AM
  5. Replies: 1
    Last Post: 06-05-2012, 02:22 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