View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default less than (<) in a formula

What do you want this to mean? Suppose C3 has 25 Dec 2006.
Let me make a guess: you want to know if this is before or after the
current date use =NOW()<C3
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"davemon" wrote in message
...
I'm attempting to write a formula with little (no) success. I have a cell
with a date in it. In another cell I would like a formula that would look
like this:
=<c3, where c3 is the cell with the current date in it. Does anyone have
an
answer? My fingers are getting sore..............
Thanks davemon