+ Reply to Thread
Results 1 to 3 of 3

List Client Appointments outside of Normal Induction dates

  1. #1
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    List Client Appointments outside of Normal Induction dates

    Hi,

    I have a workbook that logs client appointments, the bookings sheet lists the appointments for each selected month using the monday dates as the standard induction days, however clients can be inducted on any weekday so I have a seperate section that list all other client inductions that fall outside of the monday dates, the Monday dates work fine, i just cannot get the dates that fall outside of those dates to work.

    Please see the attached sheet for further details.

    Thanks in advance

    JD
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: List Client Appointments outside of Normal Induction dates

    Your formual is poiting to Appointment sheet whcih is not available in this workbook.
    On which Sheet is the outcome going to be?
    Is "User Filled Example Appoinments Sheet" section example of what you need?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Re: List Client Appointments outside of Normal Induction dates

    Hi Robert,

    The details will be listed on Bookings Display Sheet, the calc sheet cells H2 to U2 need to display the dates outside of the Monday dates.

    Hope that makes sense.

    JD

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is there a way to list blank appointments?
    By john dalton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2013, 07:35 AM
  2. [SOLVED] Dates from Excel to Outlook appointments
    By finfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 04:46 AM
  3. One spreadsheet but adding hours on a client by client basis..
    By arthurArthur in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 01:58 AM
  4. format cell to recall client name-enter a client #
    By cheryl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2005, 06:05 PM
  5. What's the easiest way to set up a client pipline w COE dates and.
    By Vanessa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2005, 08:06 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