+ Reply to Thread
Results 1 to 2 of 2

DATEIF: Count months between dates when...

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    DATEIF: Count months between dates when...

    Hi All,

    Thanks in advance for all the help. Here is my situation.

    In my spreadsheet I have a start and and end date. I need to count the months included in that span. Here's the twist - I have some that span multiple months, multiple years, and some that span only a few dates in one month. I need even one day to count as a month.

    i.e.
    1/1/13 - 12/31/14 = 24 months
    1/1/13 - 2/1/13 = 2 months
    1/1/13 - 1/15/13 = 1 month (NOT ZERO)

    How do I do this???????

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: DATEIF: Count months between dates when...

    Try this...

    A2 = start date
    B2 = end date

    =DATEDIF(A2-DAY(A2)+1,B2,"m")+1

    Format as General or Number
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count # of months between two dates and add rows
    By reltub in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-19-2012, 08:28 PM
  2. Difference between two Dates (DATEIF)
    By alpha32 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2012, 09:24 PM
  3. Count Months Between Dates
    By jpgoeth in forum Excel General
    Replies: 3
    Last Post: 05-31-2007, 12:17 PM
  4. How to Count Months in a Column of Dates
    By Dexsquab in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2006, 03:33 PM
  5. [SOLVED] CALCULATING DATES AFTER DATEIF
    By Glen in forum Excel General
    Replies: 1
    Last Post: 06-05-2005, 09:40 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