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

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()-A1>14, "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

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()-A1>14, "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