Due date calculation

Hi, I am making just a simple monthly repetitive payment spreadsheet. The date a payment is received will be entered manually, and the next cell needs to have a formula which will calculate the due date which is one month later. Also, conditional format required for the cell with the formula to change colour 3 days before the due date. All help is greatly appreciated......Cheers!!

Next date .. Payment date in A1

in B1

=EDATE(A1,1)

CF

formula.....

=B1>=TODAY()-3

Thanks John. The date formula is working fine, but I seem to be doing something wrong with the CF to change colour of the cell 3 days before due date. See attached sheet. It has changed colour even though it's one month away from the due date.

in CF use this

Formula:

Please Login or Register  to view this content.

That works. Thanks John and Tudy.

Further question. When I use the Copy-Paste Special option and choose Formula in following cells where the Start Date is not yet entered then I get a random date in the Due Date cell. How do I keep these cells blank? Sheet attached again.

Try

=IF(E2="","",EDATE(E2,1))

Originally Posted by JohnTopley

Try

=IF(E2="","",EDATE(E2,1))

I'm afraid I don't understand. Do I enter this Formula in CF? If so it doesn't work. The target cell changes colour irrespective of the date and where the Start Date is not yet entered then I still get a random date in the Due Date cell.