| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATING A CUSTOM FILL WITH WORKDAYS
Is there any way that you can enter a date, display it in days and have Excel
fill in the workdays (not weekends or holidays) from that point on? Thank you in advance for any help you can provide. Teeder |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CREATING A CUSTOM FILL WITH WORKDAYS
Don't know what version of Excel you are using but if you copy drag using
the right mouse button you'll have that option with dates in at least from Excel 2002 onwards (fill weekdays) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Teeder" wrote in message ... Is there any way that you can enter a date, display it in days and have Excel fill in the workdays (not weekends or holidays) from that point on? Thank you in advance for any help you can provide. Teeder |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CREATING A CUSTOM FILL WITH WORKDAYS
YOU ROCK!!!
Thanks!! Teeder "Peo Sjoblom" wrote: Don't know what version of Excel you are using but if you copy drag using the right mouse button you'll have that option with dates in at least from Excel 2002 onwards (fill weekdays) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Teeder" wrote in message ... Is there any way that you can enter a date, display it in days and have Excel fill in the workdays (not weekends or holidays) from that point on? Thank you in advance for any help you can provide. Teeder |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| How do I create custom fill colors (for cells) in Excel 2002? | Excel Discussion (Misc queries) | |||
| I've created a custom fill series. Now I don't know how to use i. | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Hybrid Mode
