weekend

Hello, I am using the following formula to determine a due date (you have 60 days to complete the assignments including weekends and excluding holidays) =WORKDAY.INTL(A1,60,"0000000",C1:C9) A1 = start date 60 = number of day to complete the assignment “0000000” = every day is included (no...

Hello, In excel I am trying to return a date given a "start date", "excluding holidays", and "a number of days for completion". For example, given the start date of 9/1/2015, 60 days for completion, excluding holidays, would be XX/XX/XXXX. The "WORKDAY.INTL" function would be great, but I do...

<colgroup><col><col></colgroup><tbody> Hi, I have a spreadsheet for working weekly on-call and I'm trying to create a formula for counting how many times work was carried out on a weekend between 17:00 and 19:00 hours. I tried something like this, which is not working: <code...

Is there a code or formula that would convert a weekend date to the previous friday at 11:59pm? For example: in cell A1 I have "5/23/15 8:37", which is a saturday. How could I have that number transformed into "5/22/15 23:59", which is the friday prior to that saturday? I have several other...

I am using the formula =NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1) where A2 is the start date and B2 is the end date. The NETWORKDAYS function works fine by ignoring the weekend days, however, if the end date is on a weekend then the formula doesn't work, it just gives ########. Is there a way to...

Alright guys - bit of a noob here, and I need some help. While searching online, I found this formula to calculate NETWORKDAYS down to the time (not just by date): =NETWORKDAYS(A1,B1)-1-MOD(A1,1)+MOD(B1,1) It seems to work well, and so I hope it is accurate. For my own sanity (and as an...

Bonjour, j'ai une erreur dans cette formule et je ne trouve pas pourquoi ... je dois colorer 1 weed/3 à partir du 14 mars 2015 :biggrin: Many thanks Patrick Excel 2007 <colgroup><col style="width: 25pxpx"><col><col></colgroup><thead> A B </thead><tbody> 2 sam/14/03/2015 possible to colore...

Hi all, I have some knowledge in working with date and time within excel, but now stuck with a problem, I have to calculate the total hours and minutes a call was open for during working hours only, the call could be open for only a few minutes or it could be open for days/months. Our daily...

I need to make a schedule for testing where I check the samples every 3 days but if that date hits on a weekend I want it to role over to the monday if it hits on a Sunday and Friday if it hits on a Saturday. In other words wait an extra day if it hits on a Sunday and check the sample a day...

Dear all, I am trying to create a spreadsheet which will automatically calculate the teaching dates for a teacher teaching lessons on a weekly basis. The spreadsheet should include weekends, as some teaching is taught on Sat/Sun but exclude school holidays. (It would be nice if it could copy...

Hi there, I´m developing an Excel sheet. After the user input a date in B6, all cells down to B90 are filled automatically with the right date. What I need now is to change the row background color as long as that row belongs to a "B" cell that is a holiday (Saturday or Sunday), and I need to...

I need a formula that will give a warning if the date entered in cell is a weekend day.

Hi, This is my second day on the board and my first post. I'm relatively new to ACCESS. I am building a database for work which will take an entered date from a table ( [ss_WIRB_IRB_2_Approval]![Date2Approved] ) and calculate the next quarter based on the current date. The next quarter...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I would like to use Data Validation (DV) to prevent certain cells from not being entered in a Year schedule table. I have used conditional formatting to make weekend cells turn yellow. It is...

I am putting together a weekend on-call schedule for work. I need each row to show the weekend dates for 2011. For example, Row 1 would say 1/1/2011-1/2/2011, row 2 should say 1/8/2011-1/9/2011, so on and so forth. I cannot get it to auto fill that way, so is there a formula I should use instead?

Hi all, I making some planning for my company and they make all the calculations as a working days. I need something like this: Cell A=Starting date Cell B= End date Cell C= Number of working days I want that cell B get calculated starting from A and adding C and the corresponding weekend...

I want to use VBA to find only Saturdays and Sundays from a range of dates and then put those in a new range on my worksheet. I'm ok with VBA, so whatever you throw at me will help. Thanks in advance. :cool:

hi all, i'm new here. juz found out about dis forum thru search. been scrolling around thru the posts n i'd appreciate it if sum1 take sum time n look at a minor problem i'm facing. i m living in a country dat quite a number of d population still work on Saturdays. dis causes a bit of a...