Hi,


First problem:

let's say i have a cell A1 with =today()

Why can't i use =datevalue(A1) ? or =datevalue(today()) ?

I would like to use it to count the days between a day [=datevalue("26/04/2006")] and the current day...

Second problem:

how can i do this, assuming that:

A1 = current date
B2 = some date (e.g. 26/04/2006)

=IF(A1<B2;"Some text";current day - some date)


hope i made my problem clear

greetz,
T.