less than (<) in a formula
 

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

less than (<) in a formula
 

Well it's not clear what you want to appear in the cell. Today's date is
December 20, 2006.

"Less than" 12/20/2006 includes December 20, 1900, etc. So you have an
arbitrary condition here. Be more specific: what value do you want returned?
One day less? One week? One year? Decade? Century? etc.

Dave
--
Brevity is the soul of wit.


"davemon" wrote:

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

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

less than (<) in a formula
 

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

less than (<) in a formula
 

You still haven't said what you want this new date to be. One day prior to
today? One week? One month?
--
Brevity is the soul of wit.


"davemon" wrote:

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

less than (<) in a formula
 

Hi

Then perhaps the criterion is just
<TODAY()
or
<=TODAY()
if you want to include today's date in the test.

--
Regards

Roger Govier


"davemon" wrote in message
...
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

less than (<) in a formula
 

I think you mean this.
=SUMIF(A2:A5,"<=" & TODAY(),B2:B5)


"davemon" wrote in message
...
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