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
- Automatically copy cells in excel to another sheet - How-To - Excel
- Add days to date excel - How-To - Excel
- Automatic invoice number generator excel - How-To - Excel
- Automatically run macro in excel when cell changes - How-To - Excel

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)

DON'T MISS

- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Create a Gmail Account

for example:

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

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

how to get = 0.5 days