Great, glad it fixed it

--

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


"mfg" wrote in message
...
Thanks Nick. I see you are from Southampton I am from Havent but am living
in
the northwest Territories Canada. Anyway the problem solved thanks.--
mfg41


"Nick Hodge" wrote:

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