Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,101
Default I want to count days between two dates including start date

=NETWORKDAYS(A1,B1)

earlier date in A1 returns 4 or later date in A1 returns -4

"Infinitebiscuit" wrote:

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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default I want to count days between two dates including start date

Direct from Excel help... Give it a go!

NETWORKDAYS
See Also

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.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
If necessary, follow the instructions in the setup program.
Syntax

NETWORKDAYS(start_date,end_date,holidays)

Important Dates should be entered by using the DATE function, or as
results of other formulas or functions. For example, use
DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if
dates are entered as text.

I tested it using your dates and it gave the result of 4.



On 20 Feb, 11:58, Infinitebiscuit
wrote:
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



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
report date - date rec.ved=days late, but how to rid dates complet MS Questionnairess Excel Worksheet Functions 3 January 25th 07 07:17 PM
Calculate Start Dates based on Need-By Date? GB Excel Worksheet Functions 2 February 21st 06 07:11 PM
Count number of days between dates BUT IF null to current date kathi Excel Worksheet Functions 1 February 14th 06 05:11 PM
FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES Rhonda1 Excel Worksheet Functions 4 January 31st 06 01: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 04:09 PM.

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

About Us

"It's about Microsoft Excel"