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

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

Assuming your invoice dates are running in A2 down

you could place this in say, B2:
=IF(A2="","",IF(TODAY()-A230,"Overdue",TODAY()-A2))
and copy B2 down

Col B will return the difference in days or the msg: "Overdue" if the diff
exceeds 30 days. It'll return blanks: "" if there's nothing in col A (eg
empty cells)

If you want a more elaborate text msg for overdue cases with the number of
days included, try instead in B2:
=IF(A2="","",IF(TODAY()-A230,"Overdue-"&TEXT(TODAY()-A2,"d")&"
days",TODAY()-A2))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe" wrote:
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

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

thanks

"Max" wrote:

Assuming your invoice dates are running in A2 down

you could place this in say, B2:
=IF(A2="","",IF(TODAY()-A230,"Overdue",TODAY()-A2))
and copy B2 down

Col B will return the difference in days or the msg: "Overdue" if the diff
exceeds 30 days. It'll return blanks: "" if there's nothing in col A (eg
empty cells)

If you want a more elaborate text msg for overdue cases with the number of
days included, try instead in B2:
=IF(A2="","",IF(TODAY()-A230,"Overdue-"&TEXT(TODAY()-A2,"d")&"
days",TODAY()-A2))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe" wrote:
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