Count days in excel [Solved/Closed]

- - Latest reply:  Banjo - Mar 11, 2016 at 03:02 AM
Hello,

How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.
with =NETWORKDAYS(A1,A2) not count the weekends.

Thanks
Filippos
See more 

6 replies

Best answer
approved by Jean-François Pillou
68
Thank you
To calculate the difference in days, use the DATEDIF function as shown in the following formula:
=DATEDIF(A2,B2,"d")

A2 - Start date
b2 - end date

Say "Thank you" 68

A few words of thanks would be greatly appreciated. Add comment

CCM 5985 users have said thank you to us this month

How to count the number of days considering the time
for example:

11/11/2012 7:00PM = date start

11/12/2012 7:00AM = date end

how to get = 0.5 days
Posts
436
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
108
12
Thank you
Hello Filippos,
a subtraction should work it out
=A2-A1+1

Ivan
ivan

thanks for great formula, its simple but works excellently. great :)
Sorry may I have a help on COUNTIF in excle I just want to impose more than one condition from more than one range

example
Site Date Gender

x 29-Mar-10 Female
x 29-Mar-10 Male
x 29-Mar-10 Male
M 29-Mar-10 Female
M 29-Mar-10 Female
M 29-Mar-10 Male
M 29-Mar-10 Female
M 29-Mar-10 Male
M 30-Mar-10 Male
M 31-Mar-10 Female
M 1-Apr-10 Male
M 1-Apr-10 Female
M 1-Apr-10 Female
x 1-Apr-10 Male
x 6-Apr-10 Male
x 6-Apr-10 Male
x 6-Apr-10 Male

then I want ot count female in site x from 1st april to 29th mar 2010
Kindy help me

thom
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
754 -
Thron: You can use a sumproduct for that
=SUMPRODUCT((C1:C19="Female") * (A1:A19="x") *1)
7
Thank you
How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.
3
Thank you
Hi.

To count the number of days in a range is very simple.

Eg: I want to count the number of days between 1/1/9 and 22/4/9


If cell A1 is start date (1/1/9), and cell B1 is end date (22/4/9), and the result will appear in cell C1, then the formula in C1 is simply = B1-A1

But, the trick is, you have to format cell C1 to be a General Number with no decimals, otherwise is just returns another date format response. Result in this example is 111 days.

Hope this helps.
And how do I exclude the weekends and holidays?
Can you show me the sample , such as =sum(11/05/2009),-(6/07/200).
I mean give me sample how to do it ,thank in advance /Plai
The simpleast and accurate one is C1=B1-A1, after formating the cell where the result will be inserted
this was really really helpful! thank u!
It work!! thank you! :o)
3
Thank you
using =networkdays("range") will exclude weekends. to exclude holidays, you must create a list of holidays, name this list and reference it in the network days formula... =networkdays(A1:A2, holidays)
How about if you want to include the weekends, for example 01/03/2016 - 31/03/2016 the sum should be 31 days?
2
Thank you
Thanks Ivan,

with this whenever the cells is empty indicate 1 and can't using SUM for the month