to fix cells you need to enter $ signs before column and row.
the shortcut for that would be F4 which cycles through the 4 available
states (A1,$A$1,$A1,A$1)
Your formula should look like this:
=IF(AND(A4="2d",B4="sold",$M$9<=C4,C4<=$M$10),D4,0 )

hth

Carlo

On Dec 11, 10:56 am, catherine mix <catherine
wrote:
this is my first post, and I am not sure this is the right place to post this
question, but you seem to be very knowledgeable, so here goes.
I ask the user to enter a start and end date so I can test whether an item
has sold in that date range. In the same function, I am testing for 2 other
conditions too, so the date comparison test is nested in a 3 level function.
when i copy the formula down from top to bottom, the formula thinks the
location of the start and end date should have moved down along with the data
when actually it's static on the worksheet so I have to "fix" the formula for
each row.

here's my formula
=IF(AND(A4="2d",B4="sold",M9<=C4,C4<=M10),D4,0)
where M9=start date and M10=end date

I would assign these dates to a couple of variables if I could figure out
how to do that, no luck.



"Duke Carey" wrote:
=if(today()-A290,"Due","Not Due")

Assumes the other date is in A2

"Dax Arroway" wrote:

I'm hoping this is easy but could someone please help me with a formula?

I'm trying to compare a date with today's date and if the dates are more
than 90 days apart to display "Due" in the cell.

Any helpers?

Thanks in advance!
-Dax Arroway- Hide quoted text -

- Show quoted text -