Previous Topic Next Topic

Count days in excel

Solved/Closed
Report
-
 Banjo -
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
Related:

6 replies

Answer 1 / 6

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
68
Thank you
Thank you

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

CCM 2821 users have said thank you to us this month

Report

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
Answer 2 / 6
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
 109
Hello Filippos,
a subtraction should work it out 
=A2-A1+1

Ivan
Report

ivan

thanks for great formula, its simple but works excellently. great :)
Report

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
Report

Kindy help me

thom
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
Thron: You can use a sumproduct for that
=SUMPRODUCT((C1:C19="Female") * (A1:A19="x") *1)
Answer 3 / 6

How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.
Answer 4 / 6

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.
Report

And how do I exclude the weekends and holidays?
Report

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
Report

The simpleast and accurate one is C1=B1-A1, after formating the cell where the result will be inserted
Report

this was really really helpful! thank u!
Report

It work!! thank you! :o)
Answer 5 / 6

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)
Report

How about if you want to include the weekends, for example 01/03/2016 - 31/03/2016 the sum should be 31 days?
Answer 6 / 6

Thanks Ivan,

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