troubleshooting Question

How do you find the last business day in MS Excel

Avatar of upobDaPlaya
upobDaPlaya asked on
Microsoft Excel
22 Comments4 Solutions514 ViewsLast Modified:
If in A1 I have the date of 07/01/2013, then I want to be able to determine if the date found in cell A1 equals the last business day.  I know the simplest way would be to keep a few years worth of future dates in another worksheet tab and do a VLOOKUP against the data tab.  

However, I was inquiring if there was something more elegant available within VBA I could run...
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 4 Answers and 22 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 22 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros