Home |
Search |
Today's Posts |
#1
|
|||
|
|||
i need to create an invoice that will flag up when not paid
i want an invoice that will flag up when customer not paid within a certain
time, any ideas |
#2
|
|||
|
|||
i need to create an invoice that will flag up when not paid
Not sure what you mean by "flag up"
but if you have a cell with the invoice date and you want another cell to tell you if it's overdue you can use the following assume cell A1 has invoice date "certain time"=2 weeks(14 days) in my example =IF(TODAY()-A114, "OVERDUE","") If this is not what you were looking for, please clarify your question. - Search "bgc1416" wrote: i want an invoice that will flag up when customer not paid within a certain time, any ideas |
#3
|
|||
|
|||
i need to create an invoice that will flag up when not paid
thanks search 33, going to have to try this step by step ( not the brightest
spark with computors lol, but i'll get there) but it looks like it could work and you have understood what i wanted, in a nutshell, i just need something to remind me of unpaid invoices ( we are a new social enterprise and i have the lucky/unlucky job of all accts/payroll etc ) and bills etc. many thanks "Search33" wrote: Not sure what you mean by "flag up" but if you have a cell with the invoice date and you want another cell to tell you if it's overdue you can use the following assume cell A1 has invoice date "certain time"=2 weeks(14 days) in my example =IF(TODAY()-A114, "OVERDUE","") If this is not what you were looking for, please clarify your question. - Search "bgc1416" wrote: i want an invoice that will flag up when customer not paid within a certain time, any ideas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master invoice number | Excel Worksheet Functions | |||
Create invoice from Excel worksheet | Excel Discussion (Misc queries) | |||
In Excel, how do you create a multi page Invoice Template? | Excel Discussion (Misc queries) | |||
Extracting data from a client worksheet to create an invoice | Excel Discussion (Misc queries) | |||
How do I create an invoice so every time I need a new one a new i. | Excel Worksheet Functions |