workdays

  1. C

    Workday Formula

    Hi, I'm setting up some workbooks for the new financial year 2012-13 and I've got a problem with a workdays formula that has worked perfectly well for this current year, 2011-12. Here is the formula...
  2. Y

    Calculating days

    Hi, I'm trying to get the sum of workdays between 2 given dates (A1 is the start date and B1 is the end date) with Saturday as the only non-workday (I'd like to exclude Saturday only) I used Networkdays.intl in excel 2010 for this, but I have excel 2007 on my computer. How would I do it in Excel...
  3. B

    Autofill dates excluding certain weekdays

    Hi. First post here, so I salute everyone in this forum. I'm not too savvy when it comes to Excel, but I've always been able to solve stuff (even complex stuff) just by googling a bit about it. This time is different and I've just had to register in this forum seeking help. I've even searched...
  4. K

    Use WORKDAY style function using a 6 day week

    Hi, I am tring to find work out dates going backwards using the WORKDAY function excluding holidays. This works fine apart from it omits Saturdays and I want to include them. The only things I need to omit are Sundays and public holidays. Can anyone help? I have a cell (E1) with my first...
  5. H

    Workdays function (including Sat 6 days/week)

    Dear All, I have a unique problem, I want a function like the "WORKDAY". But in that function the saturday is also used as the "Holiday" (Counted on 5 days/week) I need the Sat to be excluded from list of holidays (Counted on 6 Days/Weeks). I went thru the entire formulae given in excel...
  6. albasheer

    UDF for modified workdays

    Hello, Would someone please help me build a UDF similar to the WORKDAY(start_date,days,holidays) function, but with Fridays and Saturdays as off days instead of Saturdays and Sundays? If there is a formula solution instead of a UDF, that would also be great. Thank you.
  7. L

    Networkdays in VBA

    I know there are several posts about this on the boards, but still can't get it to work: My goal is to get the number of workdays between two dates in a VBA function. I tried simply using the Advanced Toolpak function NETWORKDAYS, but I get the error message "Sub or function not defined". I did...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top