Search results

I have this spreadsheet that manages due dates for payments, leases. The problem with this is it does not auto re-sort in MS Office format when the days start counting down. But it does auto-resort when i have it stored in google docs using the '=sort('Calendar Upcomming'!A2:B21, 2, TRUE)'...

Attached my sheet. It does not handle if you change the rent amount or rent period midway through the sheet. ---INSTRUCTIONS:-- Initially.. Enter the start date in Cell A3 Choose the rent period in Cell G8 Enter the the Rent Amount in Cell G9 Weekly.. Enter the date rent recieved in column C...