creating an aging report

[azmil]

Appreciate if the Excel MASTER can help me with this Aging Report.

I need to create a defect Summary Report for filing done.

My boss need the total number for outstanding over 30days.

date received - day outstanding over 30days ( <30 )

Is there an easy way to accomplish this in Excel ? Any specific formulas that can undertake this task smoothly ?

[FDibbins]

Hi and welcome to the forum

Hard to give precise suggestions without seeing what you are working with

However, it sounds like you need something like this. Assuming Dates are in A2 downwards...

=countif($A$2:$A$100,"<=today()-30")

If you have a lot of data, it would be better to put the =TODAY() in its own cell, and then reference it - too many =TODAY()'s tend to start slowing files down

[FDibbins]

Perhaps attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[azmil]

Hi and welcome to the forum

Hard to give precise suggestions without seeing what you are working with

However, it sounds like you need something like this. Assuming Dates are in A2 downwards...

=countif($A$2:$A$100,"<=today()-30")

If you have a lot of data, it would be better to put the =TODAY() in its own cell, and then reference it - too many =TODAY()'s tend to start slowing files down

Hi,

Thank you very much.My excel report as per attached.

[FDibbins]

Thanks for the file

Now, what do you want teh report to look like? Can you put an example together to show me what you want? (enter the data in tthe sample manually if needed)

[azmil]

My boss need total form not file more than 30days from the date we received.

For example - if i received 100 forms on 6 Jan 14, so during that 30days i not complete my work

- on 5 Feb 14 the total was 100 forms must appear in highlighted as per attached.

[FDibbins]

You dont actually have any data that is earlier than 30 days, but to test, I changed B7 from 4 Feb to 6 Jan and got 100 using this,,,

=SUMIF(B6:B397,"<="&TODAY()-30,C6:C397)

[azmil]

ok.my completed report as per attached.

My boss want me to know that each total forms not done more than 30days from each dated what we received.

So,the total must be appear at D2.

How to calculate from date received,total form received and total form not done more than 30days.

[FDibbins]

Your report still contains no dates later than 30 days, the earliest date is 3/Feb/14