PC Review


Reply
Thread Tools Rate Thread

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

 
 
RSF
Guest
Posts: n/a
 
      28th Jan 2008
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 )

Kind regards.

 
Reply With Quote
 
 
 
 
Jim Thomlinson
Guest
Posts: n/a
 
      28th Jan 2008
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 )
>
> Kind regards.
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Days between dates including start day and weekends JessP27 Microsoft Excel Worksheet Functions 7 9th Jan 2008 05:32 PM
Not including Weekends and Public Holidays! =?Utf-8?B?Sk9N?= Microsoft Access 4 17th Jan 2006 08:28 AM
Dates not including weekends and holidays =?Utf-8?B?V05CLTk2NzQw?= Microsoft Excel Programming 1 13th Jul 2005 10:03 PM
to add a # of days... not including holidays/weekends Aaron Microsoft Access Queries 2 23rd Feb 2004 09:45 PM
Counting Dates Including Weekends Karen Howard Microsoft Excel Worksheet Functions 3 21st Dec 2003 08:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:26 AM.