General discussion


Work days and holidays

By Lmcsurley1 ·
I schedule trades for Monday through Friday-the holidays. how do I put a formula in so I do not have to manuelly enter these dates. No times are needed


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by dawgit In reply to Work days and holidays

What program are you using to do your schedual? (that you help) In what country / Area are you located? (all holidays are not the same, if you are in Mexico for example I also will be clueless) And, maybe, what are you trying to schedual? (in -or- out here?) Give us a hint, then maybe somebody can help you. -d

Collapse -

by sgt_shultz In reply to Work days and holidays

like he said.
having said that,
You can create a Date Series in Excel that includes only weekdays.
Excluding of the holidays is another thing. maybe start by defining the holdays in a range. then see if you can get the Data Filter/Advanced Function to filter 'in place' the holidays out the the series
to see more stuff, look up 'date validation' and Date functions in Excel Help

Related Discussions

Related Forums