Results 1 to 11 of 11

SSP calculation to Look up between a range of dates with linked periods

Threaded View

  1. #8
    Forum Contributor mcinnes01's Avatar
    Join Date
    05-25-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    449

    Re: SSP calculation to Look up between a range of dates with linked periods

    i have had another go, I could do with a second opinion to whether it's right or not. It now looks if the next working day after the end date of the previous sick line is equal to the start day of that sickness line and includes it in the cumulative sick duration if it is.

    The only thing I can think of that is not right is, this rule ignores the greater than 3 day rule if it is a linked period, regardless of the fact that the greater than 3 day rule applies to the total of the linked period.
    Attached Files Attached Files
    Last edited by mcinnes01; 11-24-2010 at 10:12 AM.

Thread Information

Users Browsing this Thread

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

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