Sorry about not being more clear. The cell in which I need the formula is a
criteria cell in a DSUM field. So, the cell above is "Last Sale", which is a
column heading in my DSUM field, and the cell in question defines the
criteria for the DSUM function. I need the cell to contain <xx/xx/xx, where
xx/xx/xx changes as the current date changes.
I hope I haven't muddied the waters further. Sometimes crafting the
question is hardest part........
thanks again dc

"Bernard Liengme" wrote:

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