| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a list of dates (not including weekends)?
Hi.
Im facing a task where I have to generate a datelist with all the dates going from the previous time the user ran the macro to the present time. Also, if the macro could delete all the weekenddates it would be a nice feature as they are not needed here. Does anyone have any suggestions on how to do this? I feel Im far from the solution right now :o) Kind regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create a list of dates (not including weekends)?
The easiest way to create a list of dates that excludes weekends is to just
type in a starting date and then right click and drag the fill handle. When you let go of the mouse button you will get a list of options one of which is Fill Weekdays. (This solutions is not available in some older versions of XL. I think it started in XL2002.) -- HTH... Jim Thomlinson "RSF" wrote: Hi. Im facing a task where I have to generate a datelist with all the dates going from the previous time the user ran the macro to the present time. Also, if the macro could delete all the weekenddates it would be a nice feature as they are not needed here. Does anyone have any suggestions on how to do this? I feel Im far from the solution right now :o) Kind regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate 60 days from Start Date - including weekends | Excel Worksheet Functions | |||
| Days between dates including start day and weekends | Excel Worksheet Functions | |||
| Auto Fill days of the month (not including weekends) | Excel Worksheet Functions | |||
| Track time to resolution (without including after hours on weekdays and weekends) | Excel Worksheet Functions | |||
| Dates not including weekends and holidays | Excel Programming | |||
Linear Mode
