Excel 2007 : Using spreadsheet as calendar and placing last date on different spreadsheet

Hello,

I need to figure out a formula that will pull the most recent date from a calendar spreadsheet that I am using and place it on a different spreadsheet. If you look at the file I have attached you will see the calendar on the "Employee1" sheet. I need the most recent date that has hours in it (January 14 in this example) to show in B2 on Sheet1. The file I have attached is an example and I would use the formula on a much larger file with many calendars. I just need the core formula. Thank you.