+ Reply to Thread
Results 1 to 3 of 3

Calculate number of Days for a particular month from two dates

  1. #1
    Registered User
    Join Date
    03-06-2020
    Location
    Saudia Arabia
    MS-Off Ver
    2013
    Posts
    4

    Calculate number of Days for a particular month from two dates

    Hi All,


    I am trying to identify a formula that will allow me to identify how many days occurred for a particular month falls within two dates for a report I have to produce each month.
    For Example days required between 1-Apr-20 to 30-Apr-20 for the below data.
    From To
    1-Mar-20 31-Aug-20
    1-Sep-20 28-Feb-21
    1-Mar-20 31-Aug-20
    1-Sep-20 28-Feb-21
    1-Jan-20 30-Jun-20


    Anyone can help me please.
    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Calculate number of Days for a particular month from two dates

    If the numbers are entered as dates in A1 and B1 then formula for C1 =B1-A1
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    03-06-2020
    Location
    Saudia Arabia
    MS-Off Ver
    2013
    Posts
    4

    Re: Calculate number of Days for a particular month from two dates

    Thanks mehmetcik for your contribution
    but it will give number of days between two dates. Actually I need number of days for a particular month if it falls within given range. For example I need number of days for the month of April 2020 from two dates which are 1 Jan 2020 to 30 June 2020. Hope so I have delivered what actually Needed.

+ 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] Need to calculate # of days per month between two dates even if end date is blank
    By jimthe5th in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-09-2023, 01:31 AM
  2. [SOLVED] Formula to calculate the number of days between dates (month wise)
    By arun.sj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2019, 12:51 PM
  3. [SOLVED] calculate the number of days in a month through 'Month Name'
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2017, 03:10 PM
  4. [SOLVED] Calculate year month and days between two dates
    By Premmadaan in forum Excel General
    Replies: 7
    Last Post: 04-24-2017, 05:38 AM
  5. How to calculate number of days between two dates by month
    By MHayward in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2015, 12:26 PM
  6. [SOLVED] Calculate number of days in a month between two dates
    By schlomo87 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-04-2014, 12:32 AM
  7. Replies: 15
    Last Post: 06-03-2014, 02:08 PM

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