Number of days between days
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 |
Number of days between days
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 |
Number of days between days
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 |
Number of days between days
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 |
Number of days between days
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 |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com