# Can I make a cell display something if any date in a row is before today?

1. ## Can I make a cell display something if any date in a row is before today?

I currently have this formula in a cell which displays "Overdue" if the date in one particular cell (U7) is prior to today:

=IF(ISBLANK(U7),"",IF(U7<TODAY(),"Overdue",""))

This is useful but each row has 20 items and making 1 cell for each would take up a lot of space. I want the cell to display "Overdue" if any one date in the row has passed. Is there any way to do that?

2. ## Re: Can I make a cell display something if any date in a row is before today?

Try:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Can I make a cell display something if any date in a row is before today?

Brilliant, thank you

4. ## Re: Can I make a cell display something if any date in a row is before today?

Oh wait, just noticed in a few rows it throws a wobbly if they have a currency amount entered.

For example, in one column I have amounts paid. If I have a number in here, it shows "Overdue" even if there is no overdue date. Do you know why the number throws it off and is there any way around this?

5. ## Re: Can I make a cell display something if any date in a row is before today?

If it's always the same column which contains the currency - let's say for example, Column P, then use:
Formula:
`Please Login or Register  to view this content.`

6. ## Re: Can I make a cell display something if any date in a row is before today?

That's very helpful, thank you. One more question if I may - is there a way to make "Overdue" return if the date is "equal to or before" today's date, or is there only "<" for "before" today's date query?

7. ## Re: Can I make a cell display something if any date in a row is before today?

Just use "<=" instead of "<" if today's date also triggers overdue

8. ## Re: Can I make a cell display something if any date in a row is before today?

Brill, thank you very much!

There are currently 1 users browsing this thread. (0 members and 1 guests)