Formula for Date in a Cell

  • Thread starter Thread starter Frank Leist
  • Start date Start date
F

Frank Leist

I've attempted several forumulas but I can't get the
following to work:

Date in Cell A 10/20/03

Blank in Cell B but want it to alert me when the due date
is passed 6 days?

This is what I started with and seems to be the answer but
I'm missing something if it can be done:

=IF(B127>C127,"Past Due","OVERDUE RESULTS")
 
Either

=IF(TODAY()-6>A1,"Past Due","")

or

=IF(TODAY()-6>=A1,"Past Due","")

depending if you want to include the 6th day

I don't understand your formula since you refer to cell A with the date and
in the formula you refer to C127. My formula will return a blank except when
the date is past due
 
One guess as to what you're after?

Assuming you have a date in A127 (a 1st reference date)
and another later date in C127 (a 2nd reference date)
and you want to be alerted in D127:

a) if B127 is still blank 6 days after the 1st ref date in A127
(1st Alert: "Past Due")

b) if B127 is still blank 6 days after the 2nd ref date in C127
(2nd, much "higher" Alert: OVERDUE RESULTS)

Put in D127:
=IF(AND(ISBLANK(B127),TODAY()>A127+6),"Past
Due",IF(AND(ISBLANK(B127),TODAY()>C127+6),"OVERDUE RESULTS",""))
 
Put in D127:
=IF(AND(ISBLANK(B127),TODAY()>A127+6),"Past
Due",IF(AND(ISBLANK(B127),TODAY()>C127+6),"OVERDUE RESULTS",""))
Click to expand...

Oops, sorry, formula correction for above (should be the other way around)
....

Put in D127:
=IF(AND(ISBLANK(B127),TODAY()>C127+6),"OVERDUE
RESULTS",IF(AND(ISBLANK(B127),TODAY()>A127+6),"Past Due",""))
 
Back
Top