Related:

- Automatic day counter in excel
- Sum days in excel - Best answers
- Sum of days in excel - Best answers
- Counting and stop counting days in a cell ✓ - Forum - Excel
- How do i automatically add rows in excel based on cell value - Forum - Excel
- How to automatically copy cells in excel to another sheet - How-To - Excel
- Add days to date excel - How-To - Excel
- Month day year format excel - How-To - Excel

## 6 replies

Alok Parmar

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

=DATEDIF(A2,B2,"d")

A2 - Start date

b2 - end date

Ivan-hoe

- Posts
- 433
- Registration date
- Saturday February 16, 2008
- Status
- Member
- Last seen
- October 17, 2008

Hello Filippos,

a subtraction should work it out

Ivan

a subtraction should work it out

=A2-A1+1

Ivan

Thom

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

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

DateMan

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.

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.

gidge

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)

Filippos

Thanks Ivan,

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

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

for example:

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

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

how to get = 0.5 days