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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jul 14, 2009
How can you return a Vlookup as a true value in an If statement? For example
View 2 Replies
View Related
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
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
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
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
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
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