Kioskea
Recherche
Ask a question Report

Count days in excel [Solved]

Filippos - Latest answer on May 15, 2014 09:33AM
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
Read more 
Answer
+50
moins plus
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
Jap- Nov 18, 2012 07:39AM
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
Reply
Add comment
Answer
+9
moins plus
Hello Filippos,
a subtraction should work it out
=A2-A1+1

Ivan
alvi- Jan 24, 2010 09:45AM
ivan

thanks for great formula, its simple but works excellently. great :)
Reply
Thom- Jul 30, 2010 05:04AM
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
Reply
Thom- Jul 30, 2010 05:05AM
Kindy help me

thom
Reply
rizvisa1 4302Posts Thursday January 28, 2010Registration date ContributorStatus December 6, 2014Last seen - Jul 30, 2010 07:22AM
Thron: You can use a sumproduct for that
=SUMPRODUCT((C1:C19="Female") * (A1:A19="x") *1)
Reply
Add comment
Answer
+6
moins plus
How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.
Add comment
Answer
+4
moins plus
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)
Add comment
Answer
+3
moins plus
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.
paoel- Feb 25, 2009 03:01AM
And how do I exclude the weekends and holidays?
Reply
Plai- Nov 27, 2009 02:19AM
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
Reply
Thom- Jul 30, 2010 03:53AM
The simpleast and accurate one is C1=B1-A1, after formating the cell where the result will be inserted
Reply
Ash- Sep 13, 2010 08:16AM
this was really really helpful! thank u!
Reply
michelle- May 15, 2014 09:33AM
It work!! thank you! :o)
Reply
Add comment
Answer
+2
moins plus
Thanks Ivan,

with this whenever the cells is empty indicate 1 and can't using SUM for the month
Add comment
This document entitled « count days in excel » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.