#### venkateshr

##### New Member
Hi ALl,

Need to download the data from Internet explore from my company website using a VBA and then do the aging calculation based on created time - today and prepare the category then a Pivot needs to be inplace.

Sample data is mentioned below for reference. Last 2 Coloumn is manually updated by me using formula.
Ageing Formula : =NOW()-E3
Aging Range Formula : =IF(AND(J3>=7,J3<14),">7",IF(AND(J3>=14,J3<21),">14",IF(AND(J3>=21,J3<30),">21",IF(AND(J3>=30,J3<45),">30",IF(AND(J3>=45,J3<90),">45",IF(J3>=90,">90","<7"))))))
 Assignee Ticket Type Ticket ID Assigned Group Open Date Open Duration (days) Ticket Status Update Date Ticket Title Ageing Ageing Range Anthony Sathish Request Task R558732-002 ITS Voice Engineering 9/12/2014 9:56:57 AM 5 ordered 9/16/2014 11:21:19 AM Please create phone extension for new hire Aaron Hauptman - phone extension must be 429 Aaron is a 5.6 <7

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Replies
29
Views
543
Replies
3
Views
267
Replies
1
Views
853
Replies
18
Views
395
Replies
15
Views
860

1,203,099
Messages
6,053,523
Members
444,669
Latest member
Renarian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back