| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Date Function
In addition to Mike's suggestion, there is a WORKDAY() function that will
skip holidays that you list in a range and reference in the function. If you have Excel 2007, you can use WORKDAY() directly. In earlier versions (I think) you have to go to Tools-Add-ins and make sure the Analysis Toolpak is checked. "mdj0615" wrote: I have tried, and I can't figure out if this is possible. I'm trying to have dates autofill into a row of columns (C5 to V5 to be specific). I don't want week-end days to be a part of the autofill, and I can't figure out the formula. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
| Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Hybrid Mode
