Either way, counting the number of records that fall between two dates is easy using the COUNTIFS () function (which isn’t available in Excel 2003 or earlier).

Easy one for the Excel Gurus (best way to filter/sort unique item counts from a column of mixed string formats) sixstringedthing 17 minutes ago Jump to latest Follow Reply S ...

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.