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.


--
tombogman
------------------------------------------------------------------------
tombogman's Profile: http://www.excelforum.com/member.php...o&userid=30578
View this thread: http://www.excelforum.com/showthread...hreadid=536501