Count days in excel

Solved/Closed

Excel

Filippos - Oct 17, 2008 at 04:38 AM
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

Automatic day counter in excel
Stop counting days in excel when status is changed - Best answers
Automatically copy cells in excel to another sheet - Guide
How to automatically copy rows in excel to another sheet based on criteria ✓ - Forum - Excel
Automatically run macro in excel when cell changes - Guide
How to change automatic date format in excel - Guide
Automatic serial number in excel formula - Guide

6 replies

Answer 1 / 6

Alok Parmar
Jun 3, 2010 at 05:25 AM

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 at 07:39 AM

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

Alan
Sep 30, 2015 at 04:27 AM

Thanks

Answer 2 / 6

Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Oct 17, 2008 at 10:06 AM

Hello Filippos,
a subtraction should work it out

=A2-A1+1

Ivan

alvi
Jan 24, 2010 at 09:45 AM

ivan

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

Thom
Jul 30, 2010 at 05:04 AM

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

Thom
Jul 30, 2010 at 05:05 AM

Kindy help me

thom

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 30, 2010 at 07:22 AM

Thron: You can use a sumproduct for that
=SUMPRODUCT((C1:C19="Female") * (A1:A19="x") *1)

Answer 4 / 6

DateMan
Feb 20, 2009 at 10:22 PM

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 at 03:01 AM

And how do I exclude the weekends and holidays?

Plai
Nov 27, 2009 at 02:19 AM

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

Thom
Jul 30, 2010 at 03:53 AM

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

Ash
Sep 13, 2010 at 08:16 AM

this was really really helpful! thank u!

michelle
May 15, 2014 at 09:33 AM

It work!! thank you! :o)

Similar discussions

Import webpage data into Excel spreadsheet

To prepare Attendence Report with Excel sheet

Date formatting in dd/mm/yyyy

Excel make cell flash red

Comparing two columns of names in Excel

Having Excel IF formulas print text and calc

Similar discussions

Subscribe To Our Newsletter!