Results 1 to 8 of 8

Counting Sick Days using rolling 12 month calendar

Threaded View

  1. 01-13-2020, 05:04 PM #1
    bowdropper
    bowdropper is offline
    Registered User
    Join Date
    12-19-2019
    Location
    Toronto, Canada
    MS-Off Ver
    2016
    Posts
    3

    Counting Sick Days using rolling 12 month calendar

    Hi Everyone,

    I am creating an attendance tracker that needs to be able to count all sick occurrences ('SO' in the spreadsheet) during a rolling year, starting today and going back 1 year. (Ex. I need to count Person 'A's sick occurrences from last Jan 13 2019 to Jan 13 2020.) It would need to adjust the range each day.

    I have been able to figure out how to create a range that counts backwards from a certain cell using OFFSET, but I cannot make it adjust each day. Any help would be greatly appreciated!

    Column 'I' is my attempt at the formula.

    Thanks,

    Mike
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating number of sick days in a rolling year
    By nikkie456 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-18-2016, 05:53 PM
  2. Excel SumProduct and Countif Rolling Sick Days
    By Antony1979 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2016, 04:05 AM
  3. Calculating Number Of Sick Days In A Rolling Year - Exc
    By sansan88 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 08-24-2015, 02:59 PM
  4. How to calculate number of sick days taken in a rolling 365 days period based on colour
    By shazzm in forum Excel General
    Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  5. Calculate sick absence by days per month.
    By Pegs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-10-2013, 06:57 AM
  6. [SOLVED] Counting number of days sick per condition
    By burnsie in forum Excel General
    Replies: 3
    Last Post: 03-08-2013, 05:42 AM
  7. [SOLVED] Counting Vacation or Sick Days within a Specified Time Period
    By Rhonda Hewett in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 12:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1