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
|