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?
Try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Brilliant, thank you
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?
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.
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?
Just use "<=" instead of "<" if today's date also triggers overdue
Brill, thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks