Looking for Excel Formula to Calculate Past Due by 7 Days

[dsy12345]

Hello I have a list of dates, cells a2-a35. Out of these dates I want to know which one are past due. I don't want a single formula for each date but a formula that will take all the dates and either highlight or mark with an "x" in a seperate cell which are past due.

Please help.

 

[VoG]

Try

=IF(<today(),"x","")>TODAY()-A2>7,"X","")

in row 2 copied down.</today(),"x","")>

 

[dsy12345]

I can't get it to copy the formula all the way down, only in the first cell. How would I get it to take the formula and analyze all the cells and give me a response with an x in row B.

Try

=IF(<TODAY(),"X","")>TODAY()-A2>7,"X","")

in row 2 copied down.</TODAY(),"X","")>

 

[VoG]

Click in the first cell with the formula. Hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down thye left mouse button and drag down.

 

[dsy12345]

That worked!! Thank you so much.

Try

=IF(<TODAY(),"X","")>TODAY()-A2>7,"X","")

in row 2 copied down.</TODAY(),"X","")>

Click in the first cell with the formula. Hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down thye left mouse button and drag down.