Autofill weekends and holidays

G

Glenn

NM said:
Hi,
How can I set up a column with just weekend and holiday dates?

Thanks!
Click to expand...

Starting in A1 and A2, enter the first Saturday and Sunday of your range. Then
in A3 use the formula =A1+7 and copy down as far as needed. You would then have
to enter the holiday dates manually (only non-weekend dates). Copy / Paste
Special / Values and then sort.
 
S

Shane Devenshire

Hi,

Autofill can handle Weekdays but it can't handle holidays and it can't
handle weekends. The holidays because, very simply, there are different
holidays in each country, each company and each culture.

You can do them with formulas but you will need to define what your holidays
are.
 

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

Dcount -Date Criteria - Won´t find it - 0
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Date Calculation Formula- Calendar days minus Holidays 1
Calculate days help 2
Calculate next workday after adding calendar days to date in cell 13
How to implement two shifts per day with multiple teams 0
Date Calculation problem 3
Text size too small in formatting boxes 1

Top