Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 24th 06, 01:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default how I exclude weekend dates

Hi,
I am trying to work out a formula to exclude week end dates when it
calculates the work days. I tryed to instal the add inn but it does'nt work.
Pls help

  #2   Report Post  
Old October 25th 06, 12:53 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default how I exclude weekend dates

NETWORKDAYS Function help.

Returns the number of whole working days between start_date and end_date.
Working days exclude weekends and any dates identified in holidays. Use
NETWORKDAYS to calculate employee benefits that accrue based on the number of
days worked during a specific term.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

What "doesn't work"?


Gord Dibben MS Excel MVP

On Tue, 24 Oct 2006 05:44:02 -0700, Edward Chenderes <Edward
wrote:

Hi,
I am trying to work out a formula to exclude week end dates when it
calculates the work days. I tryed to instal the add inn but it does'nt work.
Pls help


  #3   Report Post  
Old March 2nd 21, 04:58 PM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 27
Default

Quote:
Originally Posted by Gord Dibben View Post
NETWORKDAYS Function help.

Returns the number of whole working days between start_date and end_date.
Working days exclude weekends and any dates identified in holidays. Use
NETWORKDAYS to calculate employee benefits that accrue based on the number of
days worked during a specific term.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

What "doesn't work"?


Gord Dibben MS Excel MVP

On Tue, 24 Oct 2006 05:44:02 -0700, Edward Chenderes <Edward
wrote:

Hi,
I am trying to work out a formula to exclude week end dates when it
calculates the work days. I tryed to instal the add inn but it does'nt work.
Pls help
To add days excluding weekends, you can do as below:

Select a blank cell and type this formula =WORKDAY(A2,B2), and press Enter key to get result.

Tip: In the formula, A2 is the start date, B2 is the days you want to add.
doc add days exluding weekend holiday 1

Now the end date which add 45 business days excluding weekends has been shown.
doc add days exluding weekend holiday 2

Note: If the calculated result is a 5-digit number, you can format it to date with clicking Home Number Format Short Date.

If you have a range of cells containing the holidays, and now you want to add days excluding weekends and these holidays to a given date, how can you handle it?

Select a blank cell and type this formula =WORKDAY(A2,B2,B4:B6), then press Enter key to get the result.


I hope these steps will be helpful!
Tim Paine


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I use conditional formatting to hilite weekend dates where. IngeD Excel Worksheet Functions 1 April 19th 06 03:50 AM
Removing Weekend dates from Day Calculations Heyna Excel Discussion (Misc queries) 2 March 3rd 06 12:41 AM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 03:54 PM
Shading row with weekend dates DKerr Excel Discussion (Misc queries) 7 September 29th 05 07:50 PM
I need to exclude duplicate patient names for dates of service is. Shannon Excel Discussion (Misc queries) 2 April 11th 05 02:53 AM


All times are GMT +1. The time now is 12:19 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017