+ Reply to Thread
Results 1 to 1 of 1

Employee Start date vs calendar year

  1. #1
    Registered User
    Join Date
    03-12-2019
    Location
    ohio
    MS-Off Ver
    2013
    Posts
    1

    Employee Start date vs calendar year

    I have downloaded an Employee attendance record Excel Sheet that keep tracks of days of such as sick day , vacation etc and it seems pretty good.
    But currently it goes from January 1st to End of December is there a way to enter a employee date of service date so it goes by that start date rather than the 1st of the year. This way it shows proper vacation and sick time since that’s when most business go by , not the calendar year.

    I added some dates by the employee s name but don’t know how to do the formula rather that what it has.

    Can anyone help?

    Here is my downloaded version
    Attached Images Attached Images
    Attached Files Attached Files

+ 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] Employee attendance tracker - viewing all together on a year calendar
    By Who_else in forum Excel General
    Replies: 5
    Last Post: 08-01-2016, 09:41 AM
  2. [SOLVED] VBA Code to calculate utilization of an Employee using Start & End Date
    By nickydharia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2014, 10:30 AM
  3. [SOLVED] Employee Utilization for the Year based on Start Date and End Date
    By nickydharia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2014, 05:55 AM
  4. Input a year to determine the start date for 4-4-5 Calendar Year.
    By mak1176 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2013, 10:34 AM
  5. Replies: 3
    Last Post: 08-14-2012, 05:14 AM
  6. Replies: 2
    Last Post: 05-15-2009, 02:42 PM
  7. [SOLVED] Get the total employee per position by entering the start and end date
    By joe41 in forum Access Tables & Databases
    Replies: 4
    Last Post: 03-02-2009, 05:41 AM

Tags for this Thread

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