Automatically updating due date

[andy51278]

Hello, I am new to the forum, I would like to ask the following question.

I want to create an excel with several bills that have to be paid every two months. These bills will have to be prioritized, meaning first on the list (highest row) will have to be the bill due to be paid first/ earliest, whilst the bills with due dates at a later day will have to follow. However, when i mark the bill highest on the list as paid, I need the due date for payment to be automatically updated and set to 2 months later, beacause all the bills in question recur every two months.

Any help on this issue will be highly appreciated............

Andy

[NeedForExcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.

Remember to desensitize the data.

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

View Pic

[andy51278]

Hello thank you for the swift feedback,

I have attached the excel. I also do not know how to insert a date in the excel box........thank you in advance

[NeedForExcel]

Hi,

Please see the file attached..

[andy51278]

Dear Sir, Thank you very very much for the invaluable help. I have inserted the real dates next to the bills.Could you please help me to prioritize this list, meaning the bill due first chronologically should be first. Can we add a shuffle/ toggle option to the due date column in order to display the bills chronologically by placing the bill due at an earlier date first, the next bill due second and etc. Then, when the due date arrives, i need to mark this bill as paid and the date will change automatically to 2 months later. For example, if the due date is 28 JULY 2015, and i mark this bill as paid, then the excel should automatically make the date 28 sep 2015.......

Again, thank you very very much..................

[NeedForExcel]

Hi,

See the file attached!