Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-04-2017, 09:13 AM
Knox05 Knox05 is offline Calculating dates in an employee attendance tracker Windows 10 Calculating dates in an employee attendance tracker Office 2016
Novice
Calculating dates in an employee attendance tracker
 
Join Date: Sep 2017
Posts: 3
Knox05 is on a distinguished road
Default

I have Saturday and Sunday as weekends to be excluded. I also have a chart (below) for the holidays for exclusion. The sick, vacation, and care days are to have the weekends and holidays excluded.

Date Holiday
January 01 2017 New Year's Day
February 20 2017 Family Day
April 14 2017 Good Friday
May 23 2017 Victoria Day
July 01 2017 Canada Day
August 07 2017 Civic Holiday
September 04 2017 Labour Day
October 09 2017 Thanksgiving Day
November 11 2017 Remembrance Day
December 25 2017 Christmas
December 26 2017 Boxing Day
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Budget Tracker Excel vill Excel 1 07-11-2017 01:14 PM
Calculating dates in an employee attendance tracker Calculating Quarterly Dates by Months not Days Artboy34 Excel 3 01-28-2016 09:47 AM
Calculating dates in an employee attendance tracker office template: employee attendance tracker LeylandRick Excel 2 01-08-2016 03:35 AM
Turn Around Time tracker call2shree Excel 2 08-05-2015 10:51 AM
Calculating dates in an employee attendance tracker Calculating dates Daria11 Word VBA 1 06-08-2011 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft