Mon-Fri are working days. We do not consider holidays here.
A2: An Excel-Date (23/09/2007), which shows month (09/2007) or year (2007).
B1: x (x-th or x-last working day of the month)
N°1: First working day of the month (being an exception to N° 2):
N°2: x-th working day since month's beginning (probably still to abbreviate
- many shifts included):
Note: No array formulas, so it can be used in Pocket Excel and other spreadsheets. Despite being longer than arrays and accessing A1 for 10 times, N°2 calculates faster, because it calculates without loops depending on B1. Roughly said it uses the ratio of 140% days compared to working days.
Holidays require array formulas at least, see 5004.htm.
N°3: x-last working day before month's end (following later)