Need help with Excel formula
Hi, I need a help with excel formula and below is the scenario, Data exisiting in the format , Basis the start date M1 will be considered and items count is given Start Date End Date Month1 Month2 Month3 Month4 Month5 Month6 Month7 Month8 Month9 Month10 Month11 Month12 1-Jan-25 31-Dec-25 1 1 1 1 1 1 1 1 1 1 1 1 1-Apr-25 31-Aug-25 1 1 1 3 3 16-Jun-25 31-Jan-26 1 1 1 1 1 2 2 3 Desired Output - Basis the start the date header Month values to be derived and item count to be update in corresponding months Start Date End Date Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 Jan-26 1-Jan-25 31-Dec-25 1 1 1 1 1 1 1 1 1 1 1 1 1-Apr-25 31-Aug-25 1 1 1 3 3 16-Jun-25 31-Jan-26 1 1 1 1 1 2 2 3