Results 1 to 10 of 10

How do I identify the number of days per month between 2 dates on Excel 2016 w/ a formula?

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2020
    Location
    Turkey
    MS-Off Ver
    2019
    Posts
    19

    How do I identify the number of days per month between 2 dates on Excel 2016 w/ a formula?

    Hello everyone!

    I am trying to identify the number of days per month between 2 specific dates which happen to not start and end in on the 1st and 31st of their respective months. For example, if the dates were 5/01/2023 and 17/03/2023, I would like to form a formula which would give me the results of 26 for January, 28 for February and 17 for March. I also need this to be a non-VBA solution.

    I have attached a sample spreadsheet of what I am trying to achieve below.

    Number of Days Worked per Month v2.xlsx

    Thank you so much for your help!
    Last edited by Allan91; 06-02-2023 at 08:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate number of Days for a particular month from two dates
    By Basit78082 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2020, 03:53 PM
  2. [SOLVED] Formula to Count The Number Of Work Days between dates and in in the fiscal month
    By LCalvert in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-30-2020, 05:26 PM
  3. [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
  4. Looking for help with excel formula to determine number of days in a month
    By sallysebern in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-11-2017, 03:44 PM
  5. Number of Days in each month between two dates
    By marshymell0 in forum Excel General
    Replies: 11
    Last Post: 06-15-2015, 01:28 AM
  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. [SOLVED] A formula to calc total number of days elapsed between two dates within any given month
    By paul.a.evans in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2014, 01:29 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