Hi, i have this code:
sheet 1
=IF(COUNT(Acte!U5:AG5),IF(TODAY()=MAX(Acte!U5:AG5 ),"Expired",INDEX(Acte!U5:AG5,,MIN(IF(Acte!U5:AG5 TODAY(),COLUMN(Acte!U5:AG5)))-COLUMN(Acte!U5:AG5)+1)-TODAY()),"")
This code is looking at range U5:AG5 (were i have payment rates) and show me
how many days i have left till the next rate.

Ex:
sheet 1
U5.........AG5
expiring dates

sheet 2
U5.........AG5
Bill's nr/date.

If in U5 i have 10.09.2009, and today is 14.09.2009 (the rate is exceeded),
i need the formula to display "please pay", until in U5 i will write bill's
nr/date. After i write nr/date in U5, then the formula to display remaining
days to next payment rate.
Can this be done?
Thanks!

Hi,

=if(sheetm!U5="","Please Pay",your formula)

if this helps please click yes thanks

"puiuluipui" wrote:

Hi, i have this code:
sheet 1
=IF(COUNT(Acte!U5:AG5),IF(TODAY()=MAX(Acte!U5:AG5 ),"Expired",INDEX(Acte!U5:AG5,,MIN(IF(Acte!U5:AG5 TODAY(),COLUMN(Acte!U5:AG5)))-COLUMN(Acte!U5:AG5)+1)-TODAY()),"")
This code is looking at range U5:AG5 (were i have payment rates) and show me
how many days i have left till the next rate.

Ex:
sheet 1
U5.........AG5
expiring dates

sheet 2
U5.........AG5
Bill's nr/date.

If in U5 i have 10.09.2009, and today is 14.09.2009 (the rate is exceeded),
i need the formula to display "please pay", until in U5 i will write bill's
nr/date. After i write nr/date in U5, then the formula to display remaining
days to next payment rate.
Can this be done?
Thanks!

Hi Eduardo, i will try and explain better, but i dont speek english so
fluent, so i guess it would be better if i can send an email to you with the
file. Anyway... the formula it's working partially, but i need 2 more things.
First i need the formula to look in a range, something like this :
if(sheetm!U5:AG5="","Please Pay",your formula)
And the second thing, i need the formula to show me "Please Pay" only after
the date has past.

A short example:
Sheet 1 (Acte)
U V W X Y....
Row 5 01.09.09 01.10.09 01.11.09 01.12.09 01.01.10
Row 6 05.05.09 05.06.09 05.07.09 05.08.09 05.09.09

Sheet 2
A ....... ....U V
W X Y
Row 5 your formula 1/01.09.09
Row 6 your formula 3/05.09.09 5/05.06.09 7/05.07.09 9/05.08.09

In A column, sheet 2,i need to put your formula.
In sheet 1 i have payment rates. In sheet 2 i will write the bill's nr/date
after i pay.
I need your formula to look in range U5:AG5 in sheet 1 and in range U5:AG5
in sheet 2 and to see were is the closest date to today.Let's say is in U5. I
need the code to compare U5 sheet 1 with U5 sheet 2. If in U5 sheet 2 has
something in it, then to look in V5 sheet 1 and V5 sheet 2. If the date has
not past, then to display remaining days to today. If the date has past, then
to look in V5 sheet 2. If V5 sheet 2 is empty, then to display Please Pay. If
V5 sheet 2 has something in it, then to compare next cells (W5 sheet 1 and W5
sheet 2.

Can this be done?
Thanks!

Hi,

=if(sheetm!U5="","Please Pay",your formula)

if this helps please click yes thanks

"puiuluipui" wrote:

Hi, i have this code:
sheet 1
=IF(COUNT(Acte!U5:AG5),IF(TODAY()=MAX(Acte!U5:AG5 ),"Expired",INDEX(Acte!U5:AG5,,MIN(IF(Acte!U5:AG5 TODAY(),COLUMN(Acte!U5:AG5)))-COLUMN(Acte!U5:AG5)+1)-TODAY()),"")
This code is looking at range U5:AG5 (were i have payment rates) and show me
how many days i have left till the next rate.

Ex:
sheet 1
U5.........AG5
expiring dates

sheet 2
U5.........AG5
Bill's nr/date.

If in U5 i have 10.09.2009, and today is 14.09.2009 (the rate is exceeded),
i need the formula to display "please pay", until in U5 i will write bill's
nr/date. After i write nr/date in U5, then the formula to display remaining
days to next payment rate.
Can this be done?
Thanks!

I need the code to do exactly what is doing now, but to do it only if there
is something in corresponding cell in sheet 2.
If the closest date to today is in U5, then the code to look in U5 sheet 2.
If the closest date to today is in V5 then the code to look in V5 sheet 2.
.....and so on.
If the date has past, and in corresponding cell is nothing, then to display
Please Pay. If there is something in corresponding cell, then to look for the
next date.(exactly like is doing now)

Thanks!

"Eduardo" wrote:

Hi,

=if(sheetm!U5="","Please Pay",your formula)

if this helps please click yes thanks

"puiuluipui" wrote:

Hi, i have this code:
sheet 1
=IF(COUNT(Acte!U5:AG5),IF(TODAY()=MAX(Acte!U5:AG5 ),"Expired",INDEX(Acte!U5:AG5,,MIN(IF(Acte!U5:AG5 TODAY(),COLUMN(Acte!U5:AG5)))-COLUMN(Acte!U5:AG5)+1)-TODAY()),"")
This code is looking at range U5:AG5 (were i have payment rates) and show me
how many days i have left till the next rate.

Ex:
sheet 1
U5.........AG5
expiring dates

sheet 2
U5.........AG5
Bill's nr/date.

If in U5 i have 10.09.2009, and today is 14.09.2009 (the rate is exceeded),
i need the formula to display "please pay", until in U5 i will write bill's
nr/date. After i write nr/date in U5, then the formula to display remaining
days to next payment rate.
Can this be done?
Thanks!