+ Reply to Thread
Results 1 to 7 of 7

Help With formula and function Absence tracker

  1. #1
    Registered User
    Join Date
    01-03-2022
    Location
    York, England
    MS-Off Ver
    18.2110.13110.0
    Posts
    16

    Help With formula and function Absence tracker

    I have been making changes to the absence tracker and I now have 2 issues.

    Calendar View is not adding on to the calendar anything but the Absence
    the network days function of the employee leave tracker tab is not working correctly - I am trying to may it count only working days so not weekends or bank holidays.

    Can anyone help?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,704

    Re: Help With formula and function Absence tracker

    Point 1: your calendar year starts in September BUT most of your leave dates are August so they will not be recorded!

    I'll look at the Networkdays issue later
    Last edited by JohnTopley; 09-04-2022 at 03:05 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,704

    Re: Help With formula and function Absence tracker

    Change to this

    =NETWORKDAYS([@[Start Date]],[@[End Date]],Settings!$G$22:$G$51)

  4. #4
    Registered User
    Join Date
    01-03-2022
    Location
    York, England
    MS-Off Ver
    18.2110.13110.0
    Posts
    16

    Re: Help With formula and function Absence tracker

    Thank you that works perfectly

  5. #5
    Registered User
    Join Date
    01-03-2022
    Location
    York, England
    MS-Off Ver
    18.2110.13110.0
    Posts
    16

    Re: Help With formula and function Absence tracker

    Hi John

    so Have I done the front calendar wrong?

    I want it to go from for example

    September 2021 to August 2022 - so on the front page calendar view the absence for that academic year can be seen?

    is that possible ?

  6. #6
    Registered User
    Join Date
    01-03-2022
    Location
    York, England
    MS-Off Ver
    18.2110.13110.0
    Posts
    16

    Re: Help With formula and function Absence tracker

    Hi Another question on the front tab calendar view the days that show also need to be the work days in the boxes at the bottom, so for example days sick 2022 - on the employee leave tracker shows correctly as 5 days absence whereas the calendar view shows 9

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,848

    Re: Help With formula and function Absence tracker

    I want it to go from for example September 2021 to August 2022
    Based on this it would seem that the date chosen in cell AN5 of the Calendar view sheet should be 2021.
    Also the dates for cells C4:D4 on the Employee Leave Tracker sheet should be 12/22/2021 and 12/30/2021 respectively.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Absence tracker: changing shift patterns in template
    By Celtic1888 in forum Excel General
    Replies: 3
    Last Post: 05-09-2022, 09:36 AM
  2. [SOLVED] Absence Tracker with rolling 6 months Bradford Factor
    By paulanderson in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-07-2020, 12:11 PM
  3. staff absence tracker inc rolling year
    By BIDD in forum Excel General
    Replies: 4
    Last Post: 09-16-2019, 02:58 PM
  4. [SOLVED] How to Exclude Weekends in Employee Absence Tracker Count
    By pugz in forum Excel General
    Replies: 20
    Last Post: 07-30-2018, 03:09 AM
  5. Absence Tracker Template by employee
    By sabrinaxiomara in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-07-2015, 09:44 PM
  6. Absence tracker problem
    By pandabear28 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2014, 05:23 AM
  7. Absence Tracker will not calculate
    By Vmgballer1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2013, 08:48 AM

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