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

Thanks!

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

Thanks!

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"NM" wrote:

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

Thanks!