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!