Include Saturdays And Maybe Sundays

May 20, 2008

currently I'm working as project manage for a software development studio and I am using MS project for all my work. Since the development team aren't aloud to have a MS project license on their PC I have to copy their tasks from MS project and put them into Excel.

I would say that I am okay using Excel but not an expert. I want to create a formula that uses NETWORKDAYS to determines a finish date from a duration and start date.

The headers I would use for each column are Duration, Start and Finish. So I would like to be able to get a team member to put a duration down i.e 1 day and give me the start day and in the finish date it produces a finish date automatically without including Bank Holidays and Weekends. What would the formula be for that?

I have the same question as Madball and was able to work out the Worday function, however for my company, we work on Saturdays and or Sundays sometimes.

I would like to be able to specify from line to line if Saturday or Sunday needs to be included in the duration calculation resulting in a finish date, however if I can simply get one formula to work that includes Saturdays alone (most common working day of the weekend, and do work more than don't) it would be the most helpful, I think I can get it adjusted from there.

View 12 Replies


ADVERTISEMENT

Highlighting Saturdays And Sundays In A Column

Jan 14, 2010

I am running Excel for Mac V2008.

My spreadsheet has various columns with column A representing dates of a 6 month period formatted as: ddd d-mmm-yy, one day per cell.

I want to highlight the cells which are Saturdays and Sundays and are not working days for my Plant.

I think it may be done using conditional formatting, but I have been unable to discover the right formula which would allow this to happen.

View 9 Replies View Related

Date Macro :: Only The Workdays (not Saturdays And Sundays)

Sep 14, 2009

i need a macro that when run will look in to a cell say A1 and see "august 2009" and will list in another sheet all the workdays for august 2009, And if possible, (i can do without this but it would be better) only the workdays (meaning skipping saturdays and sundays,)

View 9 Replies View Related

Attached Worksheet Automatically Shade Out All The Saturdays & Sundays In Any Given Month Everytime You Change The Month/Year Cell

Jul 19, 2006

Is there a way to make the attached worksheet automatically shade out all the Saturdays & Sundays in any given month everytime you change the Month/Year cell at the top of the worksheet, as example? I've tried using the weekday/Weekend formula, but can't quite get it right.

View 2 Replies View Related

Excel 2007 :: NETWORKDAYS Function - How To Include Saturdays As Workdays

Nov 26, 2011

I have never worked on workdays before so I do not know most of the available formula and play around. I googled across and found this one: [URL] .......

Where Bob has given an ARRAY formula.

Following is my layout in A1 to C3 grid (for testing purpose):
Start Date11/1/2011HOLIDAYEnd Date11/30/201111/3/2011NETWORKDAYS2011/22/2011
The formula resides in B3.

Is there any other development in 2007+ versions of Excel which can handle 6 working days in a week?

View 9 Replies View Related

Editing Macro To Include Multiple Rows And Include Text Formatting For Leading Zeros

Apr 2, 2014

I need the values that are copied from the template to copy over in text form from the "Data" Tab. Secondly, the master sheet has multiple lines for each vendor. For the area highlighted in red I'd like for it to copy all cells in column C for the vendor and search the vendor by name. Then, move to the next sheet.

View 10 Replies View Related

Add X Workdays To Date Including Saturdays

Apr 30, 2008

How to add 2 "working days" to a date, including Saturdays as work days, and excluding holidays and Sundays? Similar to: = WORKDAY ("01/02/2008", 2, 39451) But instead of resulting in Mon Jan 7th, the answer should be Sat Jan 5th. (39451 is Fri Jan 4th.)

View 4 Replies View Related

Populating Current Month Saturdays Dates Vba?

Feb 26, 2014

I have sheet1 want to populate current month all Saturdays dates in range C14 to C18 I am trying for vba or formula.

View 4 Replies View Related

Count Total Number Of Saturdays In 2013

Apr 13, 2012

the closest appears to be the number of Fridays in a particular month.

What I need to calculate is the number of Saturdays in each year from 2013 through to 2022 (by year), and the same thing for number of Sundays. I presume that it will be 52, however if a year starts on a Sunday and it is a leap year then there could well be 53.

I tried =SUMPRODUCT(--(WEEKDAY(YEAR(C1)=7))) (where C1 has 2013) to try and calculate the number of Saturdays in 2013, but it didn't work.

View 8 Replies View Related

Counting Sundays

May 18, 2009

I'm trying to either write a formula or macro that will count the number of Sundays in a given month in a given year.

I have a table that shows the days of the week for every date from now to 2020. I want to ask a user to enter a month and year (either all in one cell or two) and another cell will show the result of how many Sundays are in that month and year.

View 9 Replies View Related

Autopopulate Saturdays In Multiple Cells Based On Month Date In Another Cell

Aug 19, 2014

get other cells in a spreadsheet to populate with the Saturdays of a month based on the date input in another cell.

Example
A1 = October 2014
The following cells would automatically display:
A2 10/04/14
A3 10/11/14
A4 10/18/14
A5 10/25/14
A6 11/01/14

Then if cell A1 is changed to March 2015 the following cells would automatically display:
A2 03/07/15
A3 03/14/15
A4 03/21/15
A5 03/28/15
A6 04/04/15

I can't seem to find a way to get just the Saturdays. +7 doesn't work because Saturday is not always the 7th day of the month.

View 2 Replies View Related

Dates Excluding Sundays

Sep 27, 2007

I have a worksheet which calculates dates a product will be manufactured based on how many hours the job will run.

The first column has the starting date of the job which I input. The second column contains the date the job will finish based on a third column which contains the hours the job will run. The calculated ending date is then put into the starting date of the 2nd job. It continues to calculate down to the last job.

This calculation is based on a 24 hour day, 7 days a week. I would like to take out Sunday's in the calculation.

View 14 Replies View Related

How To Get Number Of Sundays In Month

Apr 9, 2009

I just need to enter no. of sundays in a month against the month column for five years. Is there any way to get it by using formula?

View 9 Replies View Related

Count Number Of Sundays Between Range

Feb 17, 2012

In my code I've got:

BDate = 2/29/2012
EDate = 7/31/2012

How could I compute and assign to Variable "NumSundays" the number of Sundays BETWEEN those dates in code?

View 1 Replies View Related

Autofill Dates Excluding Sundays?

Nov 17, 2012

I want to fill a column with all of 2013's dates but those falling on Sundays. how would I do that?

View 2 Replies View Related

Count Days Of Months Except Holidays Sundays

Aug 8, 2014

I want a formula that counts all days of a month "listed in a column" but excluding sunday.

View 14 Replies View Related

Days Of The Month - Automatically Remove Sundays

May 31, 2012

from a challenged Excel user who has a cell that needs to countdown the days of the month but need the ability to automatically remove Sundays. In other words the cell needs to refresh daily to show the number of days that have passed thus far and automatically know to not include Sundays. This would just be a numerical value.

View 6 Replies View Related

Calculation Of Business Hours Excluding Sundays And Holidays?

Jan 29, 2014

I want to calculate the time in hours between to dates excluding non-working hours and sundays and holidays.

My office timings: 10:00am to 05:30pm Saturday is working day. Only sundays and holidays to be excluded.

View 8 Replies View Related

How To Exclude Sundays And Other Holidays While Finding Difference Between Dates

Jul 25, 2014

find the difference between 2 dates in excel "date 1 - date 2"..... but I'm not quite sure as to how one would do it while excluding holidays!

View 8 Replies View Related

How To Display List Of Dates For The Year Excluding Sundays

Jul 5, 2009

I would like to use a formula to take the starting date in cell A1 and then have Excel give me a list of all the dates for 2009 excluding Sundays.

So A1 would be 1/01/09

Then Excel would list
Thursday, Jan 01
Friday, Jan 02
Saturday, Jan 03
Monday, Jan 05
Tuesday, Jan 06
etc....

I've tried messing with the WEEKDAY function, but can't seem to figure it out.

View 9 Replies View Related

VBA / Function To List All Dates Between Start And End Date Excluding Sundays

Feb 8, 2013

I need the VBA/UDF to produce a column of dates between a start date and end date, excluding Sundays.

I can see lots, excluding weekends, but very little for just Sundays.

View 4 Replies View Related

Include Value In The Sum Of Column C?

Jun 20, 2013

I want to sum number values in a column. I have used "=SUM(C4:C100)" and it works a treat. Now the twist. I have an adjacent column (Column D) and only want to add values in Column C, where a corresponding value is in Column D on the same row.

So for example if I have C5 as $1000 and D5 as 13/5/13, I want to include the $1000 value in the sum of Column C. However, if I have C5 as $1000 and D5 as blank, I don't want to include it in the sum.

View 3 Replies View Related

And Formula To Include 0

Jan 29, 2007

At the moment I am using the formula

=IF(AND(B3>C3,D3,E3,F3),"eat less","eat more")

I want it to show me that if B3 is bigger than any of the other cells that you should "eat less". It works if a number is entered into every cell, but if a 0 is entered into one of them it comes up with "eat more" when it should be "eat less"

View 9 Replies View Related

Include Vlookup Within If Statement

Jul 14, 2009

How can you return a Vlookup as a true value in an If statement? For example

View 2 Replies View Related

Summing Figures Which Include #N/A

Feb 3, 2010

how can I total three columns together, one with the value of #N/A, and two with figures in, without the total coming back as #N/A ?

View 10 Replies View Related

Include Cell Value In Message Box

Oct 8, 2009

I have the below macro designed to display a message box if a cell in the range specified is greater than the value in the designated cell (BF7). In the message, I'd like to include the value for the cell in another column, from the same row as the cell that met the condition.

For example:
Cell E11.........Cell BF11........Cell BF7
Mark....................1.......................0

What I want the message box to say: Mark worked too many days.

I understand how to include a cell value like so:

View 2 Replies View Related

Include 3 Arguments In IF Statement

Aug 19, 2013

I'm trying to include 3 arguments in my IF statement:

If Q40 is Yes, and if P40 is No or blank, then new. I tried the formula below but it didn't work.

=+IF(AND(Q40="Yes",IF(OR(P40="No",P40=""),"New",0)))

View 3 Replies View Related

Include Two Conditions Into IF Statement

Jan 17, 2007

I am trying to include two conditions into this IF statement.

=IF(ISBLANK('SHEET1'!W8),0,1)

I want to include the cell X8 in this aswell.

View 9 Replies View Related

SUMPRODUCT To Include More Than One Month

Jan 31, 2007

In the following formula I'm looking for MONTH 1 (January) and WEEKDAY 1 (Sunday):
=SUMPRODUCT(--(MONTH(Sheet1!$A$2:$A$6936)=1),--(WEEKDAY(Sheet1!$A$2:$A$6936)=1),--(Sheet1!$D$2:$D$6936=$D2),Sheet1!E$2:E$6936)

is it possible to find MONTH 1 and 2 (Janauary and February) and use the rest of the formula as is? Can the same thing be done looking for MONTHs 3,4,5 or months 8,9,10,and 11?

View 9 Replies View Related

Include That Weekends Are Free

Jan 13, 2006

Does anyone knows how to calculate if translator is free or not, regarding that weekends are free ( I mean if weekends are free how to check if translator is able to translate a document)

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved