Filippos -
Oct 17, 2008 at 04:38 AM - Latest reply: Banjo
- Mar 11, 2016 at 03:02 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

=DATEDIF(A2,B2,"d")

A2 - Start date

b2 - end date

Was this answer helpful? Yes No

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

Thron: You can use a sumproduct for that

=SUMPRODUCT((C1:C19="Female") * (A1:A19="x") *1)

=SUMPRODUCT((C1:C19="Female") * (A1:A19="x") *1)

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.

I mean give me sample how to do it ,thank in advance /Plai

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)

- Member requests are more likely to be responded to.
- Members can monitor the statuses of their requests from their account pages.
- A CCM membership gives you access to additional options.
- Register now

for example:

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

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

how to get = 0.5 days