+ Reply to Thread
Results 1 to 4 of 4

Calculating months on criteria

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Calculating months on criteria

    Hi,

    I need an help to put formulae for columns G and H in attached sheet. I have typed example results

    Basically i need from the revised DOJ to Jun 19 how many months inclusive of months in revised DOJ and Jun 19. Then how many months from Jul 19 to Mar 20 inclusive of both months

    If revised DOJ is from July 19 or later then how many months till Mar 20 from revised DOJ
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Calculating months on criteria

    Please Login or Register  to view this content.
    Copy down. Is that what you're after?

    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Re: Calculating months on criteria

    Yes. Thank You

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,461

    Re: Calculating months on criteria

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Calculating months
    By lacombeg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2020, 12:29 PM
  2. [SOLVED] Calculating Partial Months as Full Months
    By brg48 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2020, 10:58 AM
  3. Calculating Months/Yr including partial months
    By run2win17 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-24-2017, 10:46 AM
  4. SUMIFS with months, names, values Multiple Criteria Based on Months and Names
    By Aaron R Bauer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-25-2016, 12:07 PM
  5. SUMIFS with months, names, values Multiple Criteria Based on Months and Names
    By Aaron R Bauer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-14-2016, 06:51 PM
  6. Calculating months
    By negar in forum Excel General
    Replies: 6
    Last Post: 04-28-2009, 02:41 AM
  7. calculating the months
    By QQ29 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2006, 08:27 AM

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