View Single Post
  #2   Report Post  
Old April 22nd 10, 03:16 PM posted to microsoft.public.excel.newusers
Brad Brad is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 846
Default To find due days of debtors

What happens when you do this on the first day of the month and the invoice
is for the last day of the previous month - do you want this to be zero or one

Assuming that you want this to be zero

=MIN(4,DATEDIF(B17,TODAY(),"M"))*30

=where the invoice date is in cell B17

if you want this to be one - you would also need to compare years

Do you need this formula?
--
Wag more, bark less


"pol" wrote:

Hi all,

I am using office2007. I have an excel sheet with the following colimn
invoicedate amount period.

How I can give a formula i n period column as
if current month - month(invoicedate) = 0 then period='Current'
if current month - month(invoicedate) = 1 then period='30'
if current month - month(invoicedate) = 2 then period='60'
if current month - month(invoicedate) = 3 then period='90'
else
period='120'

it should taken care 30 or 31 or 28 and 29 days for correspodning month.

Please help have any idea
With thanks
Pol