If anyone can help with this scenario, it would be much appreciated.

I want to compare a formula driven date with today's date in a
spreadsheet. For example, if the date in one cell has already passed,
then I want to have a value in another cell. If the date is in the
future, then the value in the aforementioned cell would be null.

Originally, I put =if(a1<()today, $100, 0), but it is obviously not
correct.

Can anyone drop a clue or two?

Thanx.

PHEB


--
PHEB
------------------------------------------------------------------------
PHEB's Profile: http://www.officehelp.in/member.php?userid=4551
View this thread: http://www.officehelp.in/showthread.php?t=1217328

Posted from - http://www.officehelp.in