Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: \$10 - Determine how many days in elapsed range fell within each month

1. I agreed to these rules
Join Date
17th September 2010
Posts
16

## \$10 - Determine how many days in elapsed range fell within each month

Hi, prefer formula over VB.

1. Calculate # of days between two entered dates, assume 1 date in each column. Easy.

2. If end date is not within same month as start date, determine how many days elapsed within each month. Head-scratcher....... Elapsed days could be over 2, 3, 4, or more months.

Formating is flexible, could use separate columns for Jan, Feb, Mar, etc. if that helps.

Example: 2/20/2012 to 4/5/2012: = 10 days in Feb / 31 days in Mar / 5 days in Apr.

2. ## Re: \$10 - Determine how many days in elapsed range fell within each month

Hello Gaallen

This one has been tackled before. Fellow MVP Chip Pearson wrote a nice article about the subject:
http://www.cpearson.com/Excel/distribdates.htm

Including a sample workbook so that copy/paste formulas becomes easy :-)
http://www.cpearson.com/Zips/SplitDates.ZIP

Can you please read the article and see whether you can copy the logic to your file?

3. I agreed to these rules
Join Date
17th September 2010
Posts
16

## Re: \$10 - Determine how many days in elapsed range fell within each month

That is perfection, kind sir, and saves me a headache. May I offer you some beer money for your assistance?

4. ## Re: \$10 - Determine how many days in elapsed range fell within each month

I will send you the PayPal details.

5. ## Re: \$10 - Determine how many days in elapsed range fell within each month

Thanks!

I will not hesitate to buy some beers with it on Friday... European championships soccer will start.
Though Belgium is not there unfortunately.

See you,

Wigi

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
•
porno