?
Solved

workday function

Posted on 2011-03-08
3
Medium Priority
?
307 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 35070915
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
 

Author Comment

by:Seamus2626
ID: 35070946
So i just need to make a list and it knows to always exclude those dates?
0
 

Author Closing Comment

by:Seamus2626
ID: 35070975
Brilliant!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question