Do you need to account for holidays? This formula works but I do not account
for holidays although it'd be easy enough to do so. I am thinking some "date
wizard" (a person that is good at date formulas, that is not me!) can
probably come up with something more concise but this is a start!
A1 = the Jan 1st date of the year of interest.
A1 = 1/1/2010
Enter this formula in A2 and copy down to A25:
If you are using a version of Excel prior to Excel 2007 then this formula
requires that the Analysis ToolPak add-in be installed.
If you enter the formula and get a #NAME? error look in Excel help for
either the WORKDAY or EOMONTH functions. it will tell you how to fix the
Microsoft Excel MVP