I want to create a workbook with 5 sheets and across the top row, I want the
dates for ALL weekdays in the year so that each day is the heading for a
column. Is this possible?
I want to create a workbook with 5 sheets and across the top row, I want the
dates for ALL weekdays in the year so that each day is the heading for a
column. Is this possible?
Not possible waterskyle
There are only 256 columns and there are more days in a year
--
Regards Ron de Bruin
http://www.rondebruin.nl
"waterskyle" <[email protected]> wrote in message news:[email protected]...
>I want to create a workbook with 5 sheets and across the top row, I want the
> dates for ALL weekdays in the year so that each day is the heading for a
> column. Is this possible?
Ron's correct in that there are more weekdays in a year than columns
available in Excel. But if you can also exclude holidays, then you can use
the workday function from the analysis toolpak. With 1/2/2006 in B1, then in
C1, =workday(b1,1,holidays), and fill across.
"waterskyle" wrote:
> I want to create a workbook with 5 sheets and across the top row, I want the
> dates for ALL weekdays in the year so that each day is the heading for a
> column. Is this possible?
c1 formula should read =workday($b$1,1,holidays)
This also would only work if there were at least 6 holidays on a weekday
during the year
"bpeltzer" wrote:
> Ron's correct in that there are more weekdays in a year than columns
> available in Excel. But if you can also exclude holidays, then you can use
> the workday function from the analysis toolpak. With 1/2/2006 in B1, then in
> C1, =workday(b1,1,holidays), and fill across.
>
> "waterskyle" wrote:
>
> > I want to create a workbook with 5 sheets and across the top row, I want the
> > dates for ALL weekdays in the year so that each day is the heading for a
> > column. Is this possible?
sorry, the formula is right. One of those days.........
Same still holds true about the number of holidays required.
"bpeltzer" wrote:
> Ron's correct in that there are more weekdays in a year than columns
> available in Excel. But if you can also exclude holidays, then you can use
> the workday function from the analysis toolpak. With 1/2/2006 in B1, then in
> C1, =workday(b1,1,holidays), and fill across.
>
> "waterskyle" wrote:
>
> > I want to create a workbook with 5 sheets and across the top row, I want the
> > dates for ALL weekdays in the year so that each day is the heading for a
> > column. Is this possible?
Thank you all very much!!!
"JNW" wrote:
> sorry, the formula is right. One of those days.........
>
> Same still holds true about the number of holidays required.
>
> "bpeltzer" wrote:
>
> > Ron's correct in that there are more weekdays in a year than columns
> > available in Excel. But if you can also exclude holidays, then you can use
> > the workday function from the analysis toolpak. With 1/2/2006 in B1, then in
> > C1, =workday(b1,1,holidays), and fill across.
> >
> > "waterskyle" wrote:
> >
> > > I want to create a workbook with 5 sheets and across the top row, I want the
> > > dates for ALL weekdays in the year so that each day is the heading for a
> > > column. Is this possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks