• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Backlog value distribution year wise as per Contract end date

aparvez007

Member
Hi,

Need the formula to distribute backlog value year-wise as per the end date.
I really appreciate any help you can provide. Sample file attached.

Regards,
PaVi
 

Attachments

  • Book2.xlsx
    42.5 KB · Views: 5
C1:H1 contain real dates, the first day of each year.
Cell L1 contains the date you want to start from; adjust this.
Formula in cell C2 is copied across and down.
 

Attachments

  • Chandoo49832.xlsx
    61.4 KB · Views: 5
Back
Top