It would help to post you formula althoough if the date is in A1 you could
do

=IF(A1=NOW(),"It's greater","It's Less")

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"mfg41" wrote in message
...
Thanks in advance for any help I can get.
I am trying to place a function in a cell that will let me know if the
date
today is = or than the date in that cell. I keep getting #NAME coming up
when I try to do this. I have entered the date formula in the required
cell.
M. Foster