Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't sumproduct notice new information? | Excel Worksheet Functions | |||
Calculating Paid and unpaid bills. | Excel Worksheet Functions | |||
Deadline Notice | Excel Worksheet Functions | |||
LISTS OF BILLS TO BE PAID | Excel Worksheet Functions | |||
remove virus notice | Excel Discussion (Misc queries) |