It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.