How to create a list of dates (not including weekends)?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RSF - 28 Jan 2008 18:03 GMT

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 to this Message

Jim Thomlinson - 28 Jan 2008 18:22 GMT

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.)

Signature

HTH...

Jim Thomlinson

> Hi.
>
[quoted text clipped - 6 lines]
>
> Kind regards.

Reply to this Message