| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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. |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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. > |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
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 |
