Hi, I'm trying to return a specific value/word if a date is prior to today’s date in a range of dates. If I have 5 different dates after today then I want a cell to say "Approved" if 4 of the dates are after today and one is prior then I want the cell to say unapproved. If there are no dates in a specific cell then I want the cell to be blank. I am able to do this for just one specific cell using an IF formula but cannot work it out to look at a range.
Any help or advice would be appreciated.
Bookmarks