Can someone please provide a formula for cells C2, D2, E2 etc... that will give me the number of days within the start and end dates in columns A and B for the month entered in the column headers? Please include a formula that takes in to account the years as well Meaning I don't want the formula to calculate 62 day for the month of Jan since I only want Jan of 2019). This formula will be embedded in to a very large spreadsheet. So if you have an option for a formula that doesn't take too long to recalc would be great!
Thanks for your help!
Start Date | End date | Jan 2019 | Feb 2019 | Mar 2019 |
1/1/2018 | 2/27/2019 | 31 | 27 | 0 |
Thanks for your help!