weekends

Hi, I have a sheet where I have a start date and a number of work days to add to that start date. On that sheet I also have information if i should count Saturday and/or Sunday as workdays. I am looking for a formula to calculate the end date based off of the total days to add to the start date...

Hello, I have this formula to work out the number of instances of "S" appearing within a range. The below formula work brilliantly, however, I cannot get it to incorporate Bank Holidays. I have all the bank holidays listed in a named range called "Holidays". Can any one help with editing the...

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...

Hi Everyone, I have a simple calculation of one date minus another to produce a "lifecycle" of a process im monitoring. I need to remove the weekends from this figure as they are technically not a working day. Is there anyway of doing this? Regards Allun

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...

Hi I have a formula in VBA that will filter by date + 1 or date + 2 depending on the situation. The problem i have is that on a Friday i want date + 1 skip the weekend and filter for the Monday and for date + 2 to filter for the Tuesday. Is any one able to help? Would be greatly appreciated!

Hi I need a formula to calculate the business hours taken to complete a job. The job runs over a few days but only during business hours. I have calculated the time difference by subtracting the the 2nd date time from the 1st but that gives me total hours, i need just the business hours...

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 have events that are going to repeat x times in an exact day of the week every week. I need to calculate the date of the final event. I have done a formula using workday function when the events are going to repeat from Monday to Friday, with the advantage of calculating some holidays. I...

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...

Hi I'd like to track the status of reports when they are due. When the meetings have taken place, the reports/minutes need to be drafted by 5 working days and completed by 15 working days from the date of the meeting So currently I have in excel: A1 B1...

I am trying to identify weekends in a date range. I know that I can use the Edit>Fill>Series option and select weekdays only but I actually want to show them on my spreadsheet but grey them out. Is there any formula to do this?