+ Reply to Thread
Results 1 to 2 of 2

Count Number of Days, In a rolling 12 month period

  1. #1
    Registered User
    Join Date
    06-08-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Unhappy Count Number of Days, In a rolling 12 month period

    Gurus -

    I have to count the number of days that someone is out of the country in an 12 month rolling period.

    My data is a list of employee names, the dates that they departed and re-entered the country and that drives the total number of days out of country.
    I have to keep a track of that travel and ensure that it does not breach 90 days in any 12 month rolling period.

    Each time someone is out of country, there is a new row added.
    I will need to measure multiple destinations too.

    Appreciate any help - Bianca
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,926

    Re: Count Number of Days, In a rolling 12 month period

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    I will need to measure multiple destinations too
    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  2. [SOLVED] Count days in a rolling 12 month period
    By mlafrance in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2014, 02:08 PM
  3. Count days per month within a period
    By Cunner in forum Excel General
    Replies: 4
    Last Post: 02-03-2014, 06:12 AM
  4. Replies: 10
    Last Post: 01-09-2014, 07:04 PM
  5. Remove missed days after 12 month rolling period
    By gopherc4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2009, 06:12 PM
  6. How to count dates in a 12 month rolling period
    By butlej6 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-05-2008, 06:00 PM
  7. How do I count dates in a 12 month rolling period?
    By butlej6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2008, 05:25 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