Excel Date issue

[J7575]

Hi

I am having difficulties in formulating the following conditions in my excel spreadsheet:

1. For a specific month, I want to extract the dates that fall on Tuesday
For example in the month of Apr, the dates that fall on Tuesday would be 5/12/19/26.

2. I want to calculate the number of working days from Wed-Tues of each week within the month.

3. Working day include 1/2 day sat less out holiday that falls on the week.

4. If the start of the month to the first staturday, the total working days is less than 2, then, it will ignore this tuesday and total working day will be > 5 or so for that week.

Hope there is something that can fulfill the conditions stated above.. Thanks in advance

 

[UniMord]

Judging from what you've written, it is clear that this is for class.

It is also painfully apparent that you have no idea what your teacher wants you to do.

Excel is a very interesting program, it is a valuable skill to have, and it can be a lot of fun too. But, you'll need to master the basics first, there is no other way.

If you have a textbook, use it. If not, obtain a beginner's Excel book - there are many.

Good luck!