| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a year of weekdays automatically?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a year of weekdays automatically?
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" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a year of weekdays automatically?
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a year of weekdays automatically?
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a year of weekdays automatically?
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a year of weekdays automatically?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically updating insertion of first and last day of year | New Users to Excel | |||
| Creating a formula to show year to date total. | Excel Discussion (Misc queries) | |||
| How do you change the year but not the month automatically? | Excel Discussion (Misc queries) | |||
| Automatically changing Year | Excel Discussion (Misc queries) | |||
| i want to add a column for each day of the year automatically | Excel Discussion (Misc queries) | |||
Linear Mode
