Calculate the Days Worked on a Project

Do you manage Projects? Do you create Project work schedules? Do you need to know how many days were actually worked on your Project?

If so, this Excel video lesson is for you. A viewer asked for my help. He did not want to use MS Project for his work schedules. Rather, he wants to know which Excel Functions to use for his Project work schedules.

Excel Functions Covered in this Tutorial

In this lesson, I demonstrate how to use two functions included in the Excel “Analysis Tool-Pak”:

  • =WORKDAY()
  • =NETWORKDAYS()

Index of Excel Video Tutorials

Search for a specific Excel Video Lesson on this website in my Index.

Watch Excel Tutorial on YouTube

Click on this link to watch this Excel Tutorial on my YouTube Channel – DannyRocksExcels

Secure Online Shopping for My Resources

Want to learn how to get the most out of Excel 2007?

My DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007” is available for purchase.

 

 

The difference between what and how

“Once the ‘what’ is decided, the ‘how’ always follows. We must not make the ‘how’ an excuse for not facing and accepting the ‘what.'”

– Pearl S. Buck

I train a number of clients to improve their project management skills. The first – and most important – step in the process is to clearly identify and agree on the ‘What.’ What problem, exactly are you planning to solve? What opportunity, exactly, are you planning to take advantage of?

You define the “what”  – your goal – by asking a series of questions that begin with the word “Why.” One popular methodology is to use the question and answer system known as “The 5 whys.” Asking and answering a series of “why” questions will enable you to get to the “root problem” that you are planning to solve.

The root problem is your “What.”

Unfortunately, many projects fail because we are too anxious to start working on the “how.” And as Pearl S. Buck cautions us, “we must not make the “how” an excuse for not facing and accepting the What.”

“Our plans miscarry if they have no aim. When a man does not know which harbor he is making for, no wind is the right wind.” – Lucius Annaeus Seneca

What is our goal? What is our real problem / opportunity? Is everyone on your team able to answer these questions clearly? Do you all agree on “why” this problem / opportunity is important to solve or pursue?

If not, this is the likely scene in your place of business:

“A lot of people run full speed with incredible urgency in the wrong direction.” – Justin Menkes

Ask simple, strategic questions. Then listen to the response. If the response only reveals the explicit reason – the symptom – then continue to ask questions, and listen until you discover the implicit reason – the root cause of the problem. The late, great management guru Peter Drucker said it best:

“My greatest strength as a consultant is to be ignorant and ask a few questions.”

Once you agree on where you are going, determining how to get there becomes much easier. There will always more than one way to reach your destination – the ‘What.’ Never allow discussion of the ‘how’ to precede or interfere with your rigorous pursuit of the ‘What.’

In my training classes, we work several exercises around Rudyard Kipling’s poem, “”Six Honest Serving Men.”

“I keep six honest serving men

(They taught me all I knew);

Their names are What and Why and When

And How and Where and Who”

Learn to ask questions. Listen. Understand the difference between the “What’ and the ‘how.’ Lead with the “What” and manage the ‘how.’ 

Learning from Experience

“Life is a succession of lessons which must be lived to be understood.”

– Ralph Waldo Emerson

sales-autopsy.jpgOn a recent airplane ride, I passed the time by reading “Sales Autopsy: 50 Postmortems Reveal What Killed the Sale,” by Dan Seidman. A very humorous book. And instructive. Humorous, because some of these tales of botched sales are truly “over the top” Instructive because we learn more from our mistakes that we can from our successes. And Seidman does a good job of deconstructing the tale of each lost sale and turning it into a “lessons learned” opportunity.

However… our natural tendency is to look at the mistakes that others make and to say either, “that could never happen to me,” or “there, but for the grace of God, go I.”

We can learn by studying the mistakes that others make. But we only advance when we candidly study our own behavior with the intention of seeking continuous improvement. Self-assessment leads to self-improvement. The key questions to ask ourselves are:

“What worked – and why did it work?”

“What didn’t work so well – and why not?”

“What can I do to prevent this from recurring?”

“What have I learned- and how can I incorporate this knowledge?”

Project managers are taught to conduct “post-mortem” meetings at the conclusion of each project. “What lessons did we learn during this project?” Project managers are trained to document these lessons learned so that future projects will benefit from this body of knowledge.

Within the first five minutes of each CSI: Las Vegas, New York or Miami episode we are inside the autopsy room. Most of the evidence that drives the investigation comes from an examination of the corpse. The clues are there. But we have to be trained to know what to look for. And skilled in how we apply that information.

The CSI team is trained not to jump to conclusions but rather to follow the evidence. Follow the same routine when you perform your sales autopsy. Examine the evidence. Follow it to the root. Find the real reason why you lost the sale.

You made the sale? Great! But, before you go off for a well-deserved celebration, stop…! Do a sales autopsy. Look for the clues. What steps did you land the sale? What questions did you ask? How well did you listen to the answers? What questions did you use to follow-up? How did you demonstrate the use of the product? What approach did you use in closing the sale?

What did you learn as a result? How will you ensure that you utilize these lessons learned in the future?

“Everyone thinks of changing the world, but no one thinks of changing himself.”

– Leo Tolstoy