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