Find free desk from a list
I have a worksheet with a list of desk numbers in col A, then across row 3 I have dates.
I want to be able to type a date into a cell and return the desk numbers which are free that day (an unoccupied desk is denoted by the letters "NA")
Desk# Name Last Name Sun 01-Jan Mon 02-Jan
15 Billy Smith NA
3 Jane Jones BH NA
21 Bob Spoggs NA
48 Mary Christmas BH NA
33 Bendor Grosvenor BH BH
For example, if I type in 1/1/2017 I would get 15 and 21 returned; if I Entered 2/1/2017 I'd get 3 and 48 returned.
Any help appreciated!
|