Results 1 to 4 of 4

Calculating months on criteria

Threaded View

  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

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