How to Calculate 6 Working Days Between Two Dates

Sponsor

Excel Date Functions Question:

Guys, i have an issue with excel date functions, I have two dates ranging from 9 Nov 2007 to 3 Dec 2007. I want to calculate workdays for this mentained rangeand getting result as 17 Days by putting the formula as networkdays. Problem is that I want to consider 6 working days instead of 5 working days.

The date functions details I actualy need to fill in Excel worksheet is as follows:

Start Date: 9 Nov 2007
End Date : 3 Dec 2007
1) Sundays on : dd-mm-yy , dd-mm-yy,……..
2) Holidays on : ……..
3) Total Working days : ?? (by considering Monday to saturday as working Days)
I am not good in excel vba programing, so please provide me the simplest
solution.

Excel Date Functions Answer:

You might also try this excel vba date functions in the worksheet function ng for another option.

Microsoft Excel Date Functions example:
1. Put the 1st date in cell A1
2. Put the last date in cell A2
3. Put in cells A3 to A12 the holidays
4. Enter this in cell C1:
=GetWorkdays(A1, A2, A3:A12)

Function GetWorkdays(FirstDate As Date, LastDate As Date, _
Optional Hols As Variant) As Integer
Dim i As Integer, ii As Integer, wkdys As Integer
Dim dy As Date
Dim f As Boolean

wkdys = 0
For i = 0 To (LastDate - FirstDate)
dy = CDate(FirstDate + i)
If Weekday(dy) <> 1 Then
f = False
If Not IsMissing(Hols) Then
For ii = 1 To Hols.Count
If Len(Hols(ii)) = 0 Then Exit For
If CDate(Hols(ii)) = dy Then
f = True
Exit For
End If
Next
End If
If Not f Then wkdys = wkdys + 1
End If
Next
GetWorkdays = wkdys
End Function

Rate This Tips:

Incoming excel search terms

excel formula working days,,excel 6 day work week,excel macro working day calculation,excel vba date difference,six working days in excel,working out the difference between two dates in excel,6 working days in excel,calculate days between two dates excel,calculate days excel remove holidays,calculate remaining days in between working days in excel,calculate work week in excel,calculating the first three waiting days for sickness in excel,copying between starting date and end date vba,excel calculate business days,excel calculate difference between two dates in work hours,excel datediff business days,excel formula working day,excel workdays,excel working days saturday,how do i calculate a wrking day date less any holidays in excell,how to calculate working hours in excel,macro for formula workdays,macro to calculate workdays,working days excel formula,6 days working formula,6 working day in excel,calculate date difference considering the month in excel,calculate difference between two dates in excel,calculate duration between two dates excel,calculate duration between two dates with time in excel,calculate work days between two dates,calculate work week excel,calculate workdays between dates with 6 working days in excel,calculating work days in excel,calculation of weeks and days between two dates in excel,code to calculate days month and year between two dates vba excel,difference between dates in excel minus day,difference between two dates workdays,excel 2007 calculate work days between 2 dates,excel 2007 vba date functions days of month,excel business days between two dates,excel calculate date difference business hours,excel calculate days between two dates,excel calculate holidays,excel calculate work days with a saturday,excel calculte woring days,excel date difference workdays,excel days between two dates,excel difference between dates in working days

Related Excel Tips

• Week Functions in Vba (0)
• Quick Way Determine The First and Last Business Day of the Month (1)
• Finding Date in a String (2)
• Date Range Specific Criteria (2)
• Date Calculation Start Date Minus Year, Month and Days (3)
• Application Datevalue Function not Vba (1)
• Rename New Worksheet (0)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 14,443 views
  • Date Calculation Start Date Minus Year, Month and Days - 14,098 views
  • Macro VBA to Remove Characters in String of Text - 13,248 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 11,988 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 11,295 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 11,046 views
  • Insert Introduce Time Delay in Macro Vba - 9,598 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • Change Worksheet Tab Colors (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous