Month Attribution with timespans

Copper Contributor

I am looking for aw a way in excel to attribute a timespan to months? have a Start date of 1/1/2022 and end date of 3/15/2022. How can I get the information that this timespan covers 100% of January and February and 50% of March?

 

 

1 Reply

@Stephanbk 

See the attached demo workbook.