Try

=MAX(($B$1:$B$6)*($A$1:$A$6="Desk 1"))

Enter with Ctrl+Shift+Enter#

dates in column B

If not testing for Start/end dates!