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.

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.