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

  • Thread starter Thread starter RSF
  • Start date Start date
R

RSF

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.
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with date adding formulas! 7
Formating date ranges for weekends 3
Date input to exclude weekends 10
Date formats change (code included) 9
Identifying Weekends 1
Date find Macro 3
Date list excluding weekends 9
Multiple Week Task - Not to include weekends 2

Back
Top