holidays

Hello, I have been trying to work on this with conditional formatting for a couple of days now to no avail :( Here is a photo of the chart I'm working with: I have made it so that every time a "FILE NUMBER" is entered the cell to the right in grey shows the date it was entered in dd-Mmm-yy...

Hi, I would need a formula that would find the last Friday before the last full week of a month (week with holidays are not considered full week). For example, in 2014, the formula would give the following dates for each month: Jan 24, 2014 Feb 21, 2014 Mar 21, 2014 Apr 18, 2014 May 23, 2014...

Hello. I'm trying to create a time sheet that tallies overtime hours after 40 hours worked, with sick time, vacation and holidays, where none of these can put one into overtime. if anyone can help me with this formula, or knows of an existing template, it would be greatly appreciated! Thank you.

Need a formula that'll allow me to add days to a date and exclude weekends as well as federal holidays in the process. Example: If my date is March 25th, 2014 and I need to add 5 business days to it. The result I'm looking for is April 2, 2014 (not adding the weekends, March 29 and 30; also...

Problem with Identifying Sun & Holidays, M-F, Sat, (using Excel 2010) I have been trying to create a sheet where the user can conduct some type of analysis (MEAN, MEDIAN, MODE) over some data that occurs over a ‘SELECTABLE’ range of dates. The user should be able to select one of three sets...

Hello all, I hope some of you can relate to this pickle I am in at the moment. I'm currently working on a forecasting tool in Excel where I would like to provide a spread of a monthly forecast across the weeks in the month; weekly forecast. On top of this, I would like to account for holidays...

Can someone please help me integrate the WORKDAY formula into the formula I'm currently using? I have a form that has dates that need to be populated based on a numerical code placed into cell H46. I have the number of days for the 13 codes listed on another tab called Dates. The formula I'm...

Hello everyone and anyone that can help. I'm looking for some help to calculate holiday hours using an "H", or meeting hours using an "M", in a time cell instead of an hour to state that it is a holiday day, and distinguishing these hours from standard working hours to create two different...

I’m new to this forum, and teaching myself Excel over time, so please forgive me if I’m missing something obvious. I am having trouble with a formula identifying and skipping over holidays. It’s just a piece in a very large template I am creating, but it is crucial that Excel accounts for the...

Hello! I am hoping someone can assist with a template they just happen to have kicking around... I need to know the specific business hours from the first date/time to the second date/time, based on: a 9 hour (8-5pm) day a 5 day working week (Mon-Fri), with BC, Canada holiday dates factored...

I am trying to create the formula that will give me time elapsed for today using networkdays but exclude holidays. So I presently have =networkdays("1/10/2012",Today()) this works great but I need to take out some specific days. I dont need to worry about hours or minutes just some dates. I am...

Hey, I'm trying to count the total days between to dates but minus the fed holidays. I have a list of holidays I can ref. I like how the NETWORKDAYS function works but I need to include the weekends. Any ideas? Thanks, Tmoske

Hello, We use Excel to organize our testing enhancements. When we first open the template, a form displays to enter information regarding the enhancement including the Begin and End dates. I would like to code the text boxes where the dates are entered to check whether or not each date is a...

So I have a sales variance chart for a customers stores. One of the big factors when looking at y/y data is when holidays fall on different days/weeks from year to year. My data is summed up to a "week ending date". I have a separate list of holidays for the year and what w/e date they are on...

OK, I want to created this worksheet with the Vacation Accural Formula from scratch. Basically, I need to create a spreadsheet showing number of accumulated vacation days for an employee based on the number of days they accrue per day per year. We created a formula that basically used the...

Hello All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am trying to get a True/False returned in a formula when I reference a date.<o:p></o:p> <o:p></o:p> For example, when a date is on a predefined list/range (and/or) a Saturday or a...

Hi...thank you all for what you do here...tremendous help to the rest of us! Anyway, I'm trying to create a project schedule for the renovation of certain parts of a building. The workdays are slated to be Saturdays, Sundays, Mondays, & Tuesdays only. However, on occasion there's a holiday on a...

I am trying to make a spreadsheet that will calculate free days for our business. This formula is to exclude Holidays (which I understand how to setup in the formula) and Weekends as long as the weekends fall during the free time. Here is an example of 4 free days and charging $1 per day there...

I'm building a tool to calculate the number of days after a given date. Once the date is entered, the list in the yellow shaded cells changes to the specified number of days from that date (see example below). I'm using in the shaded cells the following formula: =WORKDAY(AI4,10,AO4:AR13). AI4...

Hello, I have the challenge of calcuting response times within 1 working day for cases filed by my clients. My current function does not account for workdays and holidays. So if a case is filed on a Friday evening and I respond on Monday morning, I have missed my allowed response time window...