• 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.

Number of days

Rajendar

Member
Dear Sir,

Please help me in excel.

I created days formulas. based on the receipts days i want to split up the number of days quantity

Please see my attachment

I am getting data only 30-60-90-180-365->365 days only. i am not getting data
365<730, days.
730<1095,
1095<1460,
1095-1825
 

Attachments

  • number of days.xlsx
    437.4 KB · Views: 14
Hi ,

You have 2 columns S and T , in between other relevant columns. These two columns are not part of the aging summary.

Remove them , and restore the formula , and everything should work correctly.

Narayan
 
Back
Top