LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default I want to count days between two dates including start date

Hi people - I count myself as a bit of a novice - so sorry if this is really
dumb! I have had a look on line and can see some similar looking enquiries -
except those want to do more complicated things than me. I simply want to put
two dates into two cells on the same row and count the number of working days
(Mon-Fri) including both start and end date.

e.g. at the moment if put in 20/06/07 - 25/06/07 it returns the value of -5
-when I want it to return a value of -6 (+2 for the weekend)= -4

Thanks for your help folks

Darren
Farnborough UK


 
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
report date - date rec.ved=days late, but how to rid dates complet MS Questionnairess Excel Worksheet Functions 3 January 25th 07 06:17 PM
Calculate Start Dates based on Need-By Date? GB Excel Worksheet Functions 2 February 21st 06 06:11 PM
Count number of days between dates BUT IF null to current date kathi Excel Worksheet Functions 1 February 14th 06 04:11 PM
FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES Rhonda1 Excel Worksheet Functions 4 January 31st 06 12:13 AM
how would I count dates (not # of days) in cells that fall betwee. sailingscotts Excel Worksheet Functions 3 August 16th 05 04:29 AM


All times are GMT +1. The time now is 11:28 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"