• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Completed days in a month based on start date and end date

Lara_1234

New Member
Experts...I have a data which has start date and end date in 2 columns.. i need to derive completed days in a month based on start and end date .

Start DateEnd date31-Jan-2328-Feb-2331-Mar-2330-Apr-2331-May-2330-Jun-2331-Jul-2331-Aug-2330-Sep-2331-Oct-2330-Nov-2331-Dec-23
01-Jan-23​
31 28 31 30 31 30 31 31 30 31 30 31
01-Jan-23​
15-Sep-23​
31 28 31 30 31 30 31 31 15 - - -
10-Apr-23​
15-Sep-23​
- - - 22 31 30 31 31 15 - - -
 

Juniad

Member
Try this formula
=SUMPRODUCT((ROW(INDIRECT($A2&":"&$B2))>=EOMONTH(C$1,-1)+1)*(ROW(INDIRECT($A2&":"&$B2))<=C$1))
See the attached workbook.
 

Attachments

Top