From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

List every Tuesday in 2022 except for holidays

List every Tuesday in 2022 except for holidays - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

List every Tuesday in 2022 except for holidays

“

- [Instructor] Here is what we have to do: list every Tuesday in the year 2022, except for holidays that fall on a Tuesday. And here in column F are all of the national holidays for this fictitious country that you and I live in with all these, this generous list of holidays. That's the objective, but it is not so easy. So pause the video, get some water or some apple juice, do some pushups, get your mind right. Think about how you're going to list all of the Tuesdays, except for the Tuesday holidays, then come back and I'll go through it, and while you're doing that I'm going to get some apple juice and do some pushups. (lively music) All right, now hopefully you got all those Tuesdays right. Here is how I'm going to go about it. First of all, I want to find out what holidays are on a Tuesday. Okay, equals text, open parentheses, the value. Boom, right there. Comma, double quote, day, day, day, double quote, close…

Contents