Help sorting rows with dates greater than 14 days prior

sklose

New Member
Joined
Apr 8, 2017
Messages
7
Hi,

I have a spreadsheet with data pulled from an accounting system. The data reads as per the below example

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Invoice Number[/TD]
[TD]Current[/TD]
[TD]+30[/TD]
[TD]+60[/TD]
[TD]+90[/TD]
[TD]+120[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Debtor Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123456[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123457[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Date[/TD]
[TD]123458[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total Debtor Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30.00[/TD]
[/TR]
</tbody>[/TABLE]


I pull the report every Monday, fortnightly, and need to chase anything that is more than 14 days old - EG - report was pulled this Monday just gone, being the 22 July 2019. So any invoices dated the 8th July onwards are not considered overdue, but anything prior to the 8th is overdue and I need to contact the client for payment.

I need to somehow sort the data to remove anything that is dated from the 8th July onwards, so I'm only left with the invoices that are outstanding by more than 14 days.

Doing this manually is taking a LOT of time. Any help is appreciated.

Thanks,
Sara
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
hello, Sara

Can you just put a filter on the whole first column/field (ALT-D-F-F) and filter for the dates within the last 2 weeks, then when they show delete the entire rows?
Once they are deleted, remove the filter (ALT-D-F-S or ALT-D-F-F) to get the desired result.

If not, can you explain why this can't be done.

thanks. regards, Fazza
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top