Autofill weekends and holidays

  • Thread starter Thread starter NM
  • Start date Start date
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.
 
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.
 
Back
Top