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(MOD(ROWS(A$2:A2),2),WORKDAY(DATE(YEAR(A$1),MONTH(A$1)+CEILING(ROWS(A$2:A2)/2,1)-1,1)-DAY(A$1)+16,-1),WORKDAY(EOMONTH(A1,0)-7,5))
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
problem.
--
Biff
Microsoft Excel MVP