I am creating a simple record of when a list of people have had meetings. They are supposed to have a meeting every 6 weeks. I want to automatically highlight anyone who has not had a meeting for more than six weeks.
I was thinking of doing that by subtracting the last meeting date entered in a row from today's date. Could you advise me how to get the value of the last date entered in a row, please? This would be the value of the last non-blank cell in e.g. B2:B20.
Thanks