These are some Microsoft Excel functions that I find useful:
MATCH: Given a key value and a row of cells, find relative position of cell in those cells that matches the key.
NETWORKDAYS: To count the number of workdays between a start date and an end date, excluding weekdays and holidays.
A1 has the start date and
A2 has the end date.