View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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.