How Do I Capture The Most Recent Date From One Sheet Onto Another Sheet?
I am trying to pull the most recent date for a specific project into a cell on another sheet and have it update automatically when a new/most recent date is put in.
Ie. The 10/27/23 date is pulled to a master sheet and updates automatically when a more recent date is put in.
I was trying to do a bunch of combinations using MAX/COLLECT, with no luck.
Help Article Resources
Check out the Formula Handbook template!