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

**Allan91** · 06-02-2023, 07:28 AM

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!

**AliGW** · 06-02-2023, 07:32 AM

Please add some expected results to the sample workbook.

**Allan91** · 06-02-2023, 07:41 AM

Do you mean, for example, fill in on of the rows? On each project, there are 2 dates - initiation and completion. I need to identify how many days per month there is going to be. The dates are due to change so if I could have the spreadsheet counting the number of days per month with a formula then I could dynamically change them when need be.

**AliGW** · 06-02-2023, 07:50 AM

I don't know what results you are expecting to see and where - I am asking you to add some that you have manually calculated to illustrate what you are aiming for.

**AliGW** · 06-02-2023, 08:00 AM

I had already seen the spreadsheet.

Let me ask in a different way: where in the spreadsheet have you mocked up some of the results that you want to see? Because all you have given us is an empty table.

**Allan91** · 06-02-2023, 08:10 AM

Hey Ali,

Thank you for the explanation. I have changed the spreadsheet and added the results I would like to get manually. Please have a look now.

**AliGW** · 06-02-2023, 08:16 AM

Thank you.

**HansDouwe** · 06-02-2023, 08:46 AM

Please try in C14 and copy down and right

Formula:

Please Login or Register  to view this content.

Note: This formula includes the Startdate and there are no weekends and holidays.

**Allan91** · 06-02-2023, 10:27 AM

Thank you Hans. This works.

**HansDouwe** · 06-02-2023, 10:46 AM

You are welcome, thanks for the feedback and rep

.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Re: How do I identify the number of days per month between 2 dates on Excel 2016 w/ a form

Thread Information

Users Browsing this Thread

Similar Threads

Calculate number of Days for a particular month from two dates

[SOLVED] Formula to Count The Number Of Work Days between dates and in in the fiscal month

[SOLVED] Formula to calculate the number of days between dates (month wise)

Looking for help with excel formula to determine number of days in a month

Number of Days in each month between two dates

[SOLVED] Calculate number of days in a month between two dates

[SOLVED] A formula to calc total number of days elapsed between two dates within any given month

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions