countdown

[puiuluipui]

Hi, i need something like this in B1: " =today-A1 ", but i need to display a
message if the date in A1 has past.
Ex 1:
A1= 08.12.2009
B1= 12
The formula to be in B1 and in this case the result to be 12.

Ex2:
A1= 08.11.2009
B1= Please pay
The formula to be in B1 and in this case the result to be "Please pay",
because the date has past. if i pay the rate and i write the next day
(08.01.2010), then the formula to calculate the days, like in Ex1.
Can this be done?
Thanks!

 

[Jacob Skaria]

In B1
=IF(A1<TODAY(),"Please pay",A1-TODAY())

If this post helps click Yes

 

[puiuluipui]

It's working!
Thanks allot!

"Jacob Skaria" a scris:

 

[puiuluipui]

I have one more question. In some cases, i will have text instead of dates.
Can this formula display another message if in A1 finds text?

A1= integral
B1= integral

Now, the code is displaying #VALUE!
If the formula finds a date, then to do the countdown, but if it finds a
text, then to display a message or the text itself.
Can this be done?
Thanks!!!

"Jacob Skaria" a scris:

 

[Jacob Skaria]

Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes

 

[puiuluipui]

Thanks allot!!!!!!

"Jacob Skaria" a scris:

Try
=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),A1)

If this post helps click Yes

 

[David Biddulph]

=IF(ISTEXT(A1),A1,IF(A1<TODAY(),"Please pay",A1-TODAY()))

 

[puiuluipui]

Hi Jacob, i have a minor problem. In A1 i will have : "Final rate" ,
"Integral" and a date.

I need this code to display a message for "Final rate" and another message
for "Integral". If the code finds a date, then to calculate countdown.
Ex:
Final rate = Final
Integral = Full
Can this be done?
Thanks allot Jacob!

"Jacob Skaria" a scris:

 

[Jacob Skaria]

(all in one line)

=IF(ISNUMBER(A1),IF(A1<TODAY(),"Please pay",A1-TODAY()),
IF(A1="Final rate","Final",IF(A1="Integral","Full","")))

If this post helps click Yes

 

[puiuluipui]

I's working great!!
Thanks!

"Jacob Skaria" a scris: