• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

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

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
matija385
Asked:
matija385
1 Solution
 
Ejgil HedegaardCommented:
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
 
matija385Author Commented:
Hi Ejgil,

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now