Results 1 to 7 of 7

Calcukate no of months between dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Calcukate no of months between dates

    Hey guys,

    I am stuck with a simple problem.

    I need to get the total number of months between 2 dates.

    I have attached my sample file.

    I need to substract Range "E" and "N".


    So far, I got

    * number of years in Range "R"
    * number of months in range "S"
    * number of days in range "T"

    I have added range "R" and "S" to get total number of months in range "AC"


    However i am stuck with the days .



    If the number of days (Range "T") is above 2 and equal to less than 17 then it must be considered half month
    If the number of days (Range "T") is equal to greater than 18 than it must be considered 1 month


    Thus,
    for example
    if number of days is 2, then its 0 months
    if its 6 days then i consider it half month (0.5 month)
    if its 19 days then i consider it 1 month



    Anyone can help me please?

    Its basically for calculating interest on morgages

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Format - Dates greater than 18 months and 24 months
    By amandavan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-03-2024, 04:08 PM
  2. Count how many dates are this month, 2 months and 3 months old
    By jimmisavage in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2017, 09:21 AM
  3. [SOLVED] Populate Dates in Other Months Based on Jan Dates
    By catnam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2015, 08:52 AM
  4. Replies: 8
    Last Post: 02-20-2014, 05:46 PM
  5. Number of months (elapsed months) between two dates
    By Timbite in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2012, 11:37 AM
  6. Months in the given dates
    By corinereyes in forum Excel General
    Replies: 3
    Last Post: 03-18-2009, 07:45 AM
  7. Adding months to dates should account for 28-30-31 day months
    By Graham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2006, 08:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1