Forum Discussion
Date Return From Calendar
Hello everyone: new here Thanks in advance Goal: I need to return the latest date a manager co-travelled with a Sales Rep. I created a basic calendar, stating in Cell A3 I put all calendar da...
Do you want to know
- One date: the last date any manger co-travelled with any sales rep
- A list of 13 dates, one for each sales rep
- A list of 5 dates, one for each manager
- A 5 by 13 list, one date for each manager/sales rep combination
HansVogelaar Thank you for replying to me Hans.
I would like to know the last date each of the 5 managers co-travelled with each of the 13 Sales Reps.
For example manager A co-traveled with Rep 1 on 1/15/24, and Co -Traveled with Rep B on 2/4/24. I would like to return the dates:
I have a separate calendar i created that houses dates and names