copy excel rows

[gmoorthy]

Is there an easy way to do the following :

i have a column which has the days for a year as follows ( weekends are not there )

1/03/1980
1/04/1980
.
.
.
.
.

12/31/1980

I want to copy this data over and over again for year 1980 to 2000 ( it is from row # 1 to row # 251)

 

[zelgar]

An easy way is using the WORKDAY function and changing the format of the cell to be a DATE. For example, if your dates started in cell A2, cell A3 would be =WORKDAY(A2,1). You can also modify this if you have a range of Holidays to skip over them as well =WORKDAY(A2,1,holidays) if holidays is a named range of holidays.

Copy & paste for all other cells to get the days you want.

What the WORDAY function does is give you the next serial number of the next workday (Mon-Fri), excluding holidays (if added in the function). Changing the format of the cell to Date gives you the date.