Filter Row using Date and Column using Null Cells

Hi,

I have attached an Excel spreadsheet. I would like to know how to hide rows based on a date which is inputted (i.e. only show row for inputted date). For the given date, I would also like it to only show the columns which contain data (i.e. hide all cells with null values).

I was thinking this may be done using a command button, with data inputbox