Insert Dates for Year
Here's one way: enter the first work day of the year, 1/2/2006, in cell
A1. Enter this formula in A2:
=WORKDAY(A1,1)
.... and format it to show day and date. The WORKDAY function returns
the workday that is a number of days after the value in A1.
|