If you do this, I suggest you either use a specific cell where you've entered the date, or, if you are hard-coding it into the formula, use the DATE function so as to avoid ambiguity due to Windows Regional Settings.You can replace TODAY() with any other date for comparison. Subtract the MAX of the matching dates from TODAY() Result is an array of all the dates that match the name Those with TRUE will return the actual date, else 0.This returns an array where if they MATCH, return TRUE, else FALSE (Using a Table and Structured References, which you can change to regular addressing if you NAME on formula row with all NAME's Then, assuming your dates in the DATE column are "real Excel Dates" and not merely text strings: and by DAYS SINCE LAST VISIT you mean the number of days between today and the most recent vist,.Best method? Depends on what you want for results, which you did not illustrate in your question
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |