Help with Compare Date Formula

D

Dax Arroway

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
 
C

catherine mix

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.
 
C

carlo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top