Paid bills notice
I would like to be notified when a payment is due the day before and then I
would like to be able to check that payment "Paid" when it's done. How do I do this? |
Paid bills notice
One simple way to set it up ..
Use 2 cols, say in cols B & C: Due date, Paid? <<col headers in B1:C1 where you would list the due dates (these must be real dates) in B2 down, and the indications whether it is paid in C2 down by the text: Yes Then you could monitor the statuses in col D like this In D2: =IF(B2="","",IF(AND(TODAY()=B2,C2<"Yes"),"Due"," ")) Copy D2 down as far as required -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "TJ" wrote: I would like to be notified when a payment is due the day before and then I would like to be able to check that payment "Paid" when it's done. How do I do this? |
All times are GMT +1. The time now is 06:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com