How can I include holidays in my monthly time sheet that appears as H for holidays instead of a regular 8hrs but can calculate as 0.
timesheet.jpg
Holidays are:
Holiday 01/19/14
Holiday 03/23/14
Holiday 07/27/14
Holiday 07/28/14
Holiday 07/29/14
Holiday 07/30/14
Holiday 07/31/14
Holiday 09/23/14
Holiday 10/05/14
Holiday 10/06/14
Holiday 10/07/14
ReschedDaysOff 10/08/14
ReschedDaysOff 10/09/14
Hello royeedominsy,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hello royeedominsy,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
This is the Introduction Forum where no questions should be posted. If you start a thread in any of the other sub-forums, I´m sure it will not take long before your request will be solved there.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks