+ Reply to Thread
Results 1 to 15 of 15

count number of months

Hybrid View

  1. 01-28-2014, 12:25 PM #1
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,645

    Re: count number of months

    Maybe DATEDIF can do this:
    =DATEDIF(F189,TODAY(),"m")
    Quang PT
    Reply With QuoteRegister To Reply
  2. 01-28-2014, 12:34 PM #2
    Dariusd7
    Dariusd7 is offline
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Re: count number of months

    Quote Originally Posted by bebo021999 View Post
    Maybe DATEDIF can do this:
    =DATEDIF(F189,TODAY(),"m")
    Sorry ..that gives the same result as the original formula..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using COUNT(IF(... to count number of months in years
    By Abid123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2014, 11:21 AM
  2. Formula to count the number of different months in a range
    By Fishkeeper in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-23-2013, 10:37 AM
  3. [SOLVED] Can i count the number of months in a specific range
    By radicrains in forum Excel General
    Replies: 12
    Last Post: 09-21-2011, 03:06 AM
  4. Count Number Of Elapsed Months
    By simonyglog in forum Excel General
    Replies: 4
    Last Post: 04-08-2011, 10:34 AM
  5. count number of months year to date
    By coal_miner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2005, 10:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1