Hi Everyone,
I am trying to build something out formulaically which will find the difference between two dates (Start and End), and then distribute it out into a 12-month calendar.
For example, with a Start date of 1/23/2019 and an End date of 4/1/2019, the difference is 68 days. I have 12 columns to the right each representing a month.
Is there a way to build a formula that runs down 12 columns dispersing the count of 68 days throughout until the End date? So there would be 8 days in Jan-19, 28 days in Feb-19,31 days in March-19 and then 1 day in April-19.
I have attached an example worksheet.
I appreciate you taking a look at my question. Thank you!
Bookmarks