With the Invoice date in B2 then you can simply use:

=TODAY()-B2 formatted as General to give the number of elapsed days and

=IF(TODAY()-B230,"Overdue","") to give the warning message.

If you want the number of working days instead of the absolute number of
days then check out the NETWORKDAYS() function.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Joe" wrote in message
...
plus I would like to get a message on the right that the invoice is
overdue
if 30days

"Joe" wrote:

How can I get the number an invoice is outstanding when I already have
todays
date and the invoice date and I want to get just a number Thanks