workday function

Does Workday formula pick up bank holidays?

I have formula

workday(today(),-1)

If a Bank Holiday is on a monday and i run a report on a Tuesday, will it pick up Monday or Friday data?

Thanks
Seamus
Seamus2626Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Workday skips Sats and Suns anyway - if you want it to skip holidays then list them somewhere, e.g. in H1:H10 and use

=workday(today(),-1,H$1:H$10)

regards, barry
0
 
Seamus2626Author Commented:
So i just need to make a list and it knows to always exclude those dates?
0
 
Seamus2626Author Commented:
Brilliant!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.