Google Sheets - Number of days since the last date a range of cells

Question

I know how to return the number of days from a specific date, it requires to input a cell. The thing is, I have an ever-growing list of emails to be sent (in new columns), so the date needs to be updated with the new column.

If 2 columns have 2 dates in, can the formula be something like =minus(TODAY(), between B6 and D6)?

Use the spreadsheet link to test please - https://docs.google.com/spreadsheets/d/1dQNMMiSvfGNSj5mJ4Uu8kbEATPSS35_Cd-wbbfrrGPM/edit?usp=sharing

Answer 1

try like this:

=DAYS(TODAY(), D6)

or perhaps like this:

=DAYS(TODAY(), MAX(B6:D6))