Help with excel file

Hello,

I have an excel file/ calendar (Equipment loan tracker 2019) that I could use some help with.  Our staff will input information in the sheet called patient equipment list.  The file should search the date column and copy the information from the "Patient Name" and "Equipment Number" to the corresponding date for that equipment.  The issue that I am having is when there are multiple entries for a date.  It will only copy the first one it finds.  How can I get it to continue to search the rest of the dates and put that information into the correct date.  Attached should be a copy of the file.  Thanks for any ideas/ help.