Related:

- Automatic day counter in excel
- How to count days in excel - Best answers
- How to track days in excel - Best answers
- Counting and stop counting days in a cell ✓ - Forum - Excel
- Add days to date excel - How-To - Excel
- How to automatically copy rows in excel to another sheet - Forum - Excel
- How to calculate per day salary in excel - Forum - Excel
- Automatic birthday wishes using excel and outlook - How-To - Office Software

Best answer

approved by Jean-François Pillou

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

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

3194 users have said thank you to us this month

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

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.

for example:

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

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

how to get = 0.5 days