| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
