Results 1 to 5 of 5

Count one month in a dates range.

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Darwin, Australia
    MS-Off Ver
    Excel 2013
    Posts
    3

    Count one month in a dates range.

    I am having difficulties finding the right formula to calculate how many selected months are in a range of dates.

    D11 | E11 | F11
    --------------------------------------------
    Name | Date1 | Date2
    --------------------------------------------
    Personnel 1 | 05-Mar-14 | 12-Apr-14
    Personnel 2 | 21-Jul-14 | 03-Aug-14
    Personnel 3 | 06-Oct-14 | 19-Oct-14
    Personnel 4 | 22-Dec-14 | 04-Jan-15

    I want to Count how many Mar, Apr, Jul, ... etc.

    Thank you.
    Last edited by metkiki; 03-27-2014 at 08:44 PM. Reason: Adding a column

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] count number of times a text appeared in a month in given range of dates and names
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2014, 08:27 AM
  2. Count days per month between two dates
    By ryets in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-24-2013, 03:16 PM
  3. Count specific dates in cell range for current month
    By rboggio1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2009, 10:21 PM
  4. Count the dates in a month
    By s2m via OfficeKB.com in forum Excel General
    Replies: 5
    Last Post: 08-04-2006, 12:40 PM
  5. count dates within range by year and month
    By Isaiah25 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-04-2005, 06:06 PM

Tags for this Thread

Bookmarks

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