Solved

Date range using macro including selected dates, exluding sundays and holidays

Posted on 2014-12-10
2
282 Views
Last Modified: 2014-12-25
Hi all,

I need help with date range using macro including selected dates, exluding sundays and holidays.

What i want to do is the following:

On sheet Saturday:

Enter Start date (B12)
Enter End date (B13)
Select type (B14)
Select if there are working saturdays (B16 checkbox)
If working saturdays (checkbox checked), macro will list dates of saturdays in date range, and then you must choose which of them will you work


On sheet Types:

There are templates of, for this example, 2 types (there will be around 6, 7 types later).

I need help with macro that will, depending on Type copy type template from sheet Type to sheet Saturday (f4) and fill the date range (in columns) from starting date to ending date (both entered by user), including saturdays selected and exluding sundays and holidays (there si a list of holidays in V column on sheet Saturday). Macro should run by pressing button GENERATE.

I don't have any macro for that, because i'm quite new to macros and don't even know where to start it :)

There is Saturday_Final result sheet where is example how it should look at the end.

If anyone can help, i would appreciate it very much.

Kind regards,
Matija

date-range.xlsm
0
Comment
Question by:matija385
2 Comments
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 40513748
Try attached file.
I have inserted some range names for start (B12) and end date (B13), type selection (B14), working saturdays (C12:D16), holidays (V2 to used), and copy insertion point (F4) on sheet Saturday.
The types on sheet Types are named Type1 and Type2.
date-range-copy-type.xlsm
0
 

Author Comment

by:matija385
ID: 40517421
Hi Ejgil,

This is perfect, just what i needed. Thank you so much.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question