+ Reply to Thread
Results 1 to 1 of 1

Calculate number of days in a month between two dates

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculate number of days in a month between two dates

    Hi there

    I'm trying to calculate the number of days in a reporting month between two dates, where the two dates may be outside of that month. In other words:
    Start date = 01/06/2014
    End date = 30/10/2014
    Current date = 04/09/2014
    Reporting month = September

    The output if I was to run the report should be 4, and if I was to run it in October in order to report on September it should be 30

    Thanks in advance

    EDIT: Sorry, found this question answered elsewhere

    http://www.excelforum.com/excel-form...ent-month.html

    Cheers
    Last edited by schlomo87; 09-04-2014 at 01:20 AM. Reason: Solution exists in another thread

+ 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. Calculate the number of working days month wise in a given period using VBA
    By rakesh3235 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-21-2014, 07:00 AM
  2. [SOLVED] How to calculate Year, Month and Day from total number of days?
    By Indra Rai in forum Excel General
    Replies: 4
    Last Post: 06-25-2014, 02:08 PM
  3. Replies: 15
    Last Post: 06-03-2014, 02:08 PM
  4. vba code needed to calculate the number of working days thus far for the month
    By Jim885 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2014, 09:38 PM
  5. [SOLVED] Formula needed to calculate working days in specified month between two dates
    By webfeet2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2013, 02:19 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