Need Formula for Dates that are 7 Days or More Past Due

[dsy12345]

Hello can someone please help me come up with a formula that will calculate dates that are 7 days or more past due. They can highlight them or mark them with a x or whatever at this point. I just need it to simply identify out of a group of dates which are 7 days or more past due.

Can someone please help me with this?

 

[Excelestial]

DUE DATES in Col A, Actual dates in Col B
in cell C2 enter...=IF(B2-A2>=7,"PAST DUE","")...run down the column as far as you need.

 

[jgrillo04]

Say a due date is in cell A1. In cell B1 enter:

=IF(A1<=TODAY()-7,"PAST DUE","")

 

[dsy12345]

I was doing this, but how can I do all the due dates at 1 time. This will only tell me for 1 due date at a time, right?

 

[dsy12345]

Can you please clarify by what you mean by "Actual Dates in column B". What value goes there?

DUE DATES in Col A, Actual dates in Col B
in cell C2 enter...=IF(B2-A2>=7,"PAST DUE","")...run down the column as far as you need.

 

[Excelestial]

Good catch, jgrillo....makes it all inclusive without there being an actual date. But if there are actual dates of payment that have come in late...then we should use both:

=IF(B1="",IF(A1<=TODAY()-7,"PAST DUE",IF(B1-A1>=7,"PAST DUE","")

 

[dsy12345]

Thank you all for your help. The dates will always be 7 days or more past due and will never include an actual "date" just always 7 days or more past due. Does that change the formula any. I'm having a little trouble with the b1-a1 because I am processing dates down a column and not across, so how would I set that up.

Good catch, jgrillo....makes it all inclusive without there being an actual date. But if there are actual dates of payment that have come in late...then we should use both:

=IF(B1="",IF(A1<=TODAY()-7,"PAST DUE",IF(B1-A1>=7,"PAST DUE","")

 

[dsy12345]

Please let me clarify. I have the dates going down a column A2-A13 and those are the dates that out of those dates I need to identify which are 7 days or older past due. The formula you all provided doesn't seem to be capturing that.

Can you help me to identify what I am doing wrong?

Good catch, jgrillo....makes it all inclusive without there being an actual date. But if there are actual dates of payment that have come in late...then we should use both:

=IF(B1="",IF(A1<=TODAY()-7,"PAST DUE",IF(B1-A1>=7,"PAST DUE","")