Desktop

Ask something
Discussion Locked

Work days and holidays

0 helpful
2 replies

by lmcsurley1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

Thanks

2 replies

by dawgit

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

by sgt_shultz

like he said.
having said that,
You can create a Date Series in Excel that includes only weekdays.
Edit/File/Series/Date/weekday
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

This discussion is closed to new replies.