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 left 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.
Bookmarks