Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Work days

Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob
 
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
Work Days Richard Excel Discussion (Misc queries) 2 July 2nd 08 07:48 PM
Work Days Formula Hany ElKady Excel Discussion (Misc queries) 10 July 23rd 06 01:35 PM
work days function tom Excel Worksheet Functions 3 July 20th 06 08:30 PM
Net Work Days Bryan Excel Discussion (Misc queries) 0 April 19th 06 09:23 PM
Counting work days Hausma Excel Discussion (Misc queries) 1 April 10th 05 10:13 PM


All times are GMT +1. The time now is 07:42 PM.

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

About Us

"It's about Microsoft Excel"