# Days in particular month between two dates

1. ## Days in particular month between two dates

Hi,

Attched example, have a start date (col E) & end date (col F) then months Dec-10 through to Jun-12 as columns heading from G-W. Looking for a a formula that will give me the number of days that fall between the start & end date for the month in the column heading, hoping someone can assist.

Many thanks

Branno

2. ## Re: Days in particular month between two dates

Assuming you include both start and end date in the count try this formula in G2 copied across and down

=MAX(0,MIN(\$F2,EOMONTH(G\$1,0))-MAX(\$E2,G\$1)+1)

3. ## Re: Days in particular month between two dates

Let you know if this is what you want?

4. ## Re: Days in particular month between two dates

You marked your question as solved.

Please respond if this (#3) what you up to.

Or did you use the solution of daddylonglegs?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1