LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 157
Default Calculating every work day between two dates

Hi

It sounds like you want the list the days (like a calendar) starting from
A2. I assume the days you need are Monday to Friday.

If you can guarantee that the starting date is a weekday, then in A2 put

=A1

otherwise put

=IF(WEEKDAY(A1+1,2)-50,A1+8-WEEKDAY(A1,2),A1)

In A3 put

=IF(A2$B$1,"",IF(WEEKDAY(A2+1,2)-50,A2+8-WEEKDAY(A2,2),A2+1))

and copy it down at least as far as you need. The first part of the formula
will ensure that once the second date is reached, any further rows will be
blank.

--
Ian
--
"Zsolt Szabó" wrote in message
...
Hello everybody!
Here is my problem. I have a date (08/28/2008) in cell A1. The column A is
in date format *Wednesday, March 14, 2001. I have a second date in cell B1
09/26/2008.
I like to calculate every working (business) day between the two dates and
like to sort them under A1 in column A. The two dates in A1 and B1 should
be
included on the list.

--
Many thanks for your help in advance. Have a wonderful day!
Zsolt



 
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
calculating hours work has taken Marty Excel Discussion (Misc queries) 9 April 21st 08 07:36 PM
calculating adjacent columns in a work schedule HB Designs Excel Worksheet Functions 0 June 15th 06 06:23 PM
Calculating total work week hours Harley mom Excel Worksheet Functions 2 December 20th 05 05:41 PM
Counting dates in multiple work sheets and work books Savage Excel Discussion (Misc queries) 0 December 19th 05 11:41 PM
Calculating number of days between two dates that fall between two other dates [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM


All times are GMT +1. The time now is 08:36 AM.

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"